Extracting ledger master data to Microsoft Excel using ODBC

Extracting ledger master data to Microsoft Excel using ODBC

Using ODBC , you can extract ledger data to Microsoft Excel and generate the required reports.

Illustration

National Traders wants to extract information from the ledger master, as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

To extract ledger data to Microsoft Excel

1. Open Microsoft Excel on your computer.

2. Click Data Get External Data From Other Sources From Microsoft Query as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

3. Select TallyODBC64_9000* , as ODBC is enabled on the server 9000.

4. Click OK The Query Wizard – Choose Columns screen appears as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

5. Click Ledger and expand the list to select the required fields.

6. Click Next . The Query Wizard – Filter Data screen with the column names appears as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

7. Click Next . The Query Wizard – Sort Order screen appears as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

o Select Ascending or Descending for each drop down list under Sort by , as required.

8. Click Next The Query Wizard – Finish screen appears as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

o Select the option Return Data to Microsoft Office Excel .

o Click Finish . The Import Data screen appears as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

9. Click OK . The Microsoft Excel sheet with the imported data appears as shown below:

Extracting ledger master data to Microsoft Excel using ODBC

Similarly, any data can be extracted from Tally.ERP 9 by using the Microsoft Excel Query Wizard.

CALL US FOR ANY QUERY WE ARE GLAD TO HELP YOU OUT @9811782542 & 9911721597
Are You Looking For tally odbc 9000 not showing in excel      
Are You Looking For how to enable odbc port in tally application    
Are You Looking For tally odbc tables          
Are You Looking For tally odbc 9000 driver download      
Are You Looking For  data source name not found and no default driver specified tally
Are You Looking For tally odbc connection string        
Are You Looking For how to export ledger address details from tally to excel  
Are You Looking For how to export ledger details from tally to excel    
see our latest products
Sale!
2,950.00 Inclusive of taxes
0.00 Inclusive of taxes
23,895.00 Inclusive of taxes
53,100.00 Inclusive of taxes

Busy Softwares

Busy Upgrades

5,310.0032,391.00 Inclusive of taxes
Sale!
1,180.00 Inclusive of taxes
Sale!

Cloud Service

Busy On Cloud

1,180.00141,600.00 Inclusive of taxes

Welcome to our website !

error: Content is protected !!