Two reasons. First, you may have opened the 32-bit ODBC administrator by mistake. Second, your Tally driver might require TallyODBC64.ini in the same folder. Create a blank text file named TallyODBC64.ini in the Tally directory.
Select the tables you need (e.g., Ledgers, Stock Items) to import the data. Third-Party Drivers
Once the driver is active, you can pull live data directly into Excel: Open Excel and navigate to the From Other Sources TallyODBC64_9000 (or your specific configured port) from the list.