17 Jan 2008
Tally ODBC with Microsoft Excel
Tally ODBC extracts data from Tally and designs the reports in MS Excel. The steps to be followed are:
Start Tally and keep it open till the Mail Merge process is completed.
Ensure ODBC Server is displayed on Tally's calculator pane.
Open MS Excel.
Click on Data > Get External Data > New Database Query from the Menu.
Select TallyODBC from the Choose Data Source dialog box.
The screen appears as:
Query Wizard displays fields from Tally. Select and click the ">" button to select fields required in your query.
The screen appears as:
Use the Filter Data dialog box to limit the data to suit your requirement.
Sort your data in ascending or descending order in the Sort Order dialog box.
Click on Finish to complete the Query process.
Click on OK from the Returning External Data to Microsoft Excel dialog box to display the selected columns on the Excel sheet.
The screen appears as:
Labels: connect, Excel, odbc, Tally 9, Tally 9.0
polo lacoste
fendi
tommy hilfiger
uggs outlet
puma shoes
jordan
nike air max 95
cheap eyeglasses
goyard handbags
2018.2.8xukaimin
michael kors
canada goose
polo ralph
nike outlet store
coach outlet online
canada goose outlet
ray ban
cheap jordans
nike air huarache
20182.26chenjinyan
nike blazer low
christian louboutin shoes
yeezy boost 350
saints jerseys
issey miyake
buffalo bills jerseys
moncler outlet
michael kors outlet clearance
coach outlet online
kate spade outlet
Subscribe to Post Comments [Atom]
<< Home
Subscribe to Posts [Atom]