After updating to TallyPrime, while extracting data in Excel, the following error appears:
The specified DSN contains an architecture mismatch between the Driver and Application.
This error message appears when you extract data from a 64-bit version of Tally.ERP 9 into 32-bit version of Microsoft Excel through ODBC. This also appears when you extract the data from a 32-bit version of Tally.ERP 9 into 64-bit version of MS Excel.
TallyPrime is a 64-bit supported application. If you are using 32-bit Excel, you will need to install MS query of 64 bit and try.