Each Excel workbook is logically considered to be a database that holds several tables. Tables are mapped to sheets in a workbook. When you configure an ODBC data source name in the ODBC driver manager, you specify a default workbook name associated with that data source, however, when you issue a CREATE TABLE statement, you can override the default and specify a workbook name in the location string.
See”Microsoft Excel (Microsoft 3.51.171300)” in SQL Anywhere Server - SQL Usage.