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.