Microsoft Excel DBMS Notes
Microsoft Excel Driver (*.xls) 4.00.6200.00
- Driver does not support deleting data
In order to see Excel database tables in CompareData each table must have a header
row that has the table column names.
- A worksheet named range is mapped as a user table that has the same name as the worksheet range name.
named ranges (tables) may exist in the same worksheet.
- A worksheet is mapped as a system table. In order to see Excel worksheets (system
tables) in a CompareData tables comparison,
you must set the System Table
filter for the Excel data source tables
comparison to Yes.
[Microsoft][ODBC Excel Driver] The connection for viewing your linked Microsoft
Excel worksheet was lost
Worksheet is open in Excel. Close the worksheet.
Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm,
[Microsoft][ODBC Excel Driver] Cannot modify the design of table '<tableName>'.
It is in a read-only database.
Add readOnly=false to the data source Driver-specific Parameters in
CompareData Data Source Setup dialog.