funnyheavenly

ODBC - in Tally.ERP 9. However, there is a driver requirement if, the Operating System is 64 Bit, while. Tally.ERP 9 is 32 bit and MS Office is 64-bit. Sep 28, 2001 - (If you have an ODBC driver, you can skip this step, and use The JBDC-ODBC bridge.). A monospace font presents file and path names. JDBC drivers can be downloaded from To retrieve the data faster and in a more easily customized way, use the.

1. Odbc Driver Not Marked
2. Odbc Driver Manager Not Found

Dear All,

After writting my previous post related to How to Link Tally With Excel, so many freinds raised queries as they find difficulties to connect with Tally with Excel as 'No Specified drivers Specified'. On that period of time I was unable to make any comment over the problems faced by the uses.

But, doing my reasearch, Here I am posting step by step how to link Tally With Excel Along with suggested solution over the ealier problems faced by the users:

Using the ODBC feature available in Tally.ERP 9 the user can extract the necessary data in Excel and generate the required reports.

1. To extract data from Tally.ERP 9 in Excel execute the following steps:
2. Start Tally.ERP 9. It should be open till the Mail Merge process is complete.
3. Ensure that the words ODBC Server is visible in the Information Panel under Configuration section of Tally.ERP 9 screen.
4. Open Excelsheet
5. Go to Data > From Other Sources > From Microsoft Query(Import data for an unlisted format by using the Microsoft Query Wizard)

• Choose the Tally.ERP 9 Source (Example: TallyODBC 9000*)

• Click OK

The screen displayed above appears when Tally.ERP 9 exe is 32 Bit.

Note: If Tally.ERP 9 - 64 Bit, the screen appears as shown below: Observe that the DSN (Data Source Name) selected is TallyODBC64_9000, where 9000 is the ODBC Server port number.

Odbc Driver Not Marked

1. The Query Wizard window opens
2. Select Ledger

Expand the list under Ledger and select the required fields and move the required fields to the right side

• Click Next

Map the Parent as Sundry Debtors (if only Sundry debtors are required) or Sundry Creditor (if only Sundry Creditors are required) or select both one by one, based on the requirement.

1. Click Next
2. If any sorting is required select the sorting
3. Click Next
4. Click on Save QuerySave the Query in a particular path (Eg. C:Documents and SettingsUserApplication DataMicrosoftQueriesQuery from TallyODBC_9000.dqy)
5. Click on Finish

1. The customer data can also be seen in the Excel sheet.
2. Click OK in the Import Data window to import the data to Excel

• Press OK

Exceptional cases for 64 Bit compatible scenarios

There are three important elements whose bitness determine the Export via ODBC process:

• Tally.ERP 9,
• Operating System,
• andMS Office

The ODBC feature works seamlessly when, the Operating System, Tally.ERP 9 and MS Office are all 64-bit. The method for this is as shown above.

However, there is a driver requirement if, the Operating System is 64 Bit, while

• Tally.ERP 9 is 32 bit and MS Office is 64-bit.
• Tally.ERP 9 is 64 bit and MS Office is 32-bit.

As can be seen, in both cases there is a bitness mismatch between Tally.ERP 9 and MS Office. Due to this, Tally.ERP 9 (which acts as the ODBC Server) will not be able to communicate with MS Excel and hence data will not be exported.

Odbc Driver Manager Not Found

Now, to enable data export, a driver is to be installed.

In the first scenario, to export data via ODBC,

• Open the Tally Application folder
• Select the tool regodbc64.exe and Run as Administrator. This will install the driver tallywin64.dat

In the second scenario,

• Select the tool regodbc32.exe and
• Run as Administrator. This will install the driver tallywin32.dat

To summarise,

Once the driver has been installed, you can continue with the export process in MS Excel.

Best Regards,

KumarMuke$h

In Case you still find some difficulties, you are free to call at 9999219030 or at camukeshkumar6610 @ consultant.com