|
|
Ispirer SQLWays Database Migration Software
Syntax for specifying Excel table names
An Excel file contains one or more sheets. You can refer these sheets as tables using an Excel ODBC driver. But you have to use the Excel syntax to refer to Excel tables.
For example, an Excel file contains the Contacts sheet. To refer this table using the Excel ODBC driver, add a $ character to the table name. So you have to specify the table as Contacts$ in queries.
In cases when you specify Contacts$ and the Excel ODBC driver returns "Syntax error in from clause", enclose the table name in brackets. So you have to specify the table as [Contacts$] in queries.
|
|