## SQLWays Troubleshooting Guide

#### Excel Files

This chapter presents troubleshooting tips for exporting data from Excel files.

- Syntax for specifying Excel table names

#### 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.

[Main] [Table of Contents]
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.