In TDA 3.0.0 base when using an Excel (either .xls or .xlsx) in the cross connection editor, errors are received. Single connection, single table (name table or not), any Excel file.
1. Create the query in general editor (i.e. select * from test_1... test_1 being a table in the Excel), paste into cross connection editor. Run with F9
Error: "Error on line 1, col 15, offset 14: Restricted by TDA3 compatibility subset of MySQL"
2. Create the query directly in the cross connection editor. Run with F9:
Error: "[Microsoft][ODBC Microsoft Access Driver] You cannot use ODBC to import from, export to, or link an external Microsoft Access or ISAM database to your database."
In some cases a slightly different error is received: "[Microsoft][ODBC Microsoft Access Driver] Reserved error (-1001); there is not message for this error".
This is not an issue in 3.0.1. Please upgrade TDA to address issue.
