The specified DSN contains an architecture mismatch between the Driver and Application.

Cause:

This error message appears when you extract data from a 64-bit version of Tally.ERP 9 in 32-bit version of Microsoft Excel through ODBC or the data is extracted from a 32-bit version of Tally.ERP 9 in 64-bit version of MS Excel.

Solution:

1.    Right click on regodbc32.exe if you have installed 64-bit version of Tally.ERP 9 or click on regodbc64.exe if you have installed 32-bit version of Tally.ERP 9.

2.    Click Run as administrator as shown below:

3.    Open MS Query from MS Excel and choose any one configured port.

4.    Now you will be able to extract data from Tally.ERP 9 through ODBC.