Excel connection issues
In version 5.0.1, and above a new driver is being used for excel connections, and this article no longer applies.
Issue: Error occurs when connecting to Excel file
- Unable to discover table structure.
- You get the error below when you drag and drop the excel file on the dashboard:
Make sure that you have 64-bit 'Microsoft Access Database Engine 2010' installed.
- Install the 64-bit Microsoft Access Database Engine 2010 on the server.