Microsoft Excel DBMS Notes

ODBC Driver

Microsoft Excel Driver (*.xls) 4.00.6200.00 Pass
Tables

In order to see Excel database tables in CompareData each table must have a header row that has the table column names.

  1. A worksheet named range is mapped as a user table that has the same name as the worksheet range name. Excel filterMultiple named ranges (tables) may exist in the same worksheet.
  2. 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, *.xlsb) 14.00.4760.1000 PassExcel ReadOnly data source parameter
[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.

See Also

DBMS Notes