You can connect to Microsoft Excel workbooks in format
*.xls containing “database-like” tabular data.
The Excel workbook should have column names at first row of sheets followed by data rows.
The data type of all values in a column should all be the same. Trying to parse an Excel file where a column has a number as first value and string as second value will result in a parsing error in SQL buffer.
Other complex sheet designs may not be supported.
Formulas are executed every time the file is opened.
Selecting Connection Type
In the “Create Connection” dialog change the Connection “Type” by selecting “Excel” (should be selected by default) :
Click to browse for an Excel file.
The Excel Connection presents Excel Sheets as tables to be used in a Data Source.
Data refresh and Buffer
The Excel Connector is bufferized.
If you need to get new data, see Chapter The data Buffer