Using Sage 2021, seems the ODBC driver for excel only support .xls files. When attempting to connect to a .xlsx, get SqlState error S1000 that the table is not in the expected format
Any way to use the driver with xlsx?
*Community Hub is the new name for Sage City