ExcelDataSource is available for access to Excel pages (xls files):
The Excel data source differs from general relational databases in a few points:
- A sheet corresponds to a table.
- Table names are entered directly for standard SQL requests. The syntax is different for SQL requests to Excel:
select * from [Artikel$];
The table name (here Parts) must be placed in square brackets for Excel. The $ character must be placed at the end.
- Excel itself defines the data type of the column:
- Everything is text by default.
- Once a column contains only cells of a single type (e.g., number), this type will also become the type of the column.
- Individual cells that deviate from the specified column type are ALWAYS supplied as NULL via the jdbc:odbc driver.
- Unicode is not supported in Excel documents.