Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.


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.


Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.