I've just updated to Office 2016 on my new Windows 10 laptop.
A script that was previously working is now failing:
SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ODBC CONNECT32 To [Excel Files;DBQ=C:\Users\SpecialDates.xlsx]
my bit of script is:
ODBC CONNECT32 To [Excel Files;DBQ=$(vFile)]; Sheets_temp: SQLTABLES; DISCONNECT ;