To use Excel spreadsheets with the Database Exchange control, you either configure a DSN or use a connection string directly in ODBC Connection Strings for ADO, such as:
Provider=MSDASQL.1;Persist Security Info=False;Data Source =XLS
An XLS file is actually a workbook that may contain multi-sheets, and each sheet may contain multi-tables. There are some tricks to use an Excel spreadsheet as a data source with Database Exchange control. The syntax for table name should be [SheetName$].
SELECT *FROM Employees WHERE FirstName LIKE 'AN%'
Be aware that the first row of each column in a sheet is used as the column (field) name.
Note:When using Excel as your data source you can modify existing rows, but can not add rows to the worksheet.