Connection could not be validated when using Excel data source
By David Youngquist, Senior Support EngineerFriday, September 6, 2019
Using an Excel data source, and receiving an error that says “Connection could not be validated”. When clicking on Details, the message says “ERROR [IM002][Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified”
This is caused by not having 32 Bit Excel/Office ODBC Drivers installed on this machine.
When you click on the “Download” button it will ask you what version. Make sure you download the top one that is named “AccessDatabaseEngine.exe” and NOT the one that says “AccessDatabaseEngine_X64.exe”. The top one is the 32 bit driver, the bottom one is the 64 bit driver.
Then when you setup your data source, Pick Excel 2010 as the data type.