The Jet\3.5\ISAM Formats\Excel 3.0 folder contains the following entries.
Entry name |
Windows NT 3.51 type |
Windows 95 and Windows NT 4.0 type |
Value |
| Engine | REG_SZ | String | Excel |
| ExportFilter | REG_SZ | String | Microsoft Excel 3 (*.xls) |
| CanLink | REG_BINARY | Binary | 01 |
| OneTablePerFile | REG_BINARY | Binary | 00 |
| IsamType | REG_DWORD | DWORD | 1 |
| IndexDialog | REG_BINARY | Binary | 00 |
| CreateDBOnExport | REG_BINARY | Binary | 01 |
| ResultTextExport | REG_SZ | String | Export data from the current database into a Microsoft Excel 3.0 file. This process will overwrite the data if exported to an existing file. |
The Jet\3.5\ISAM Formats\Excel 4.0 folder contains the following entries.
Entry name |
Windows NT 3.51 type |
Windows 95 and Windows NT 4.0 type |
Value |
| Engine | REG_SZ | String | Excel |
| ExportFilter | REG_SZ | String | Microsoft Excel 4 (*.xls) |
| CanLink | REG_BINARY | Binary | 01 |
| OneTablePerFile | REG_BINARY | Binary | 00 |
| IsamType | REG_DWORD | DWORD | 1 |
| IndexDialog | REG_BINARY | Binary | 00 |
| CreateDBOnExport | REG_BINARY | Binary | 01 |
| ResultTextExport | REG_SZ | String | Export data from the current database into a Microsoft Excel 4.0 file. This process will overwrite the data if exported to an existing file. |
The Jet\3.5\ISAM Formats\Excel 5.0 folder contains the following entries, which apply to Microsoft Excel versions 5.0 and 7.0.
Entry name |
Windows NT 3.51 type |
Windows 95 and Windows NT 4.0 type |
Value |
| Engine | REG_SZ | String | Excel |
| ExportFilter | REG_SZ | String | Microsoft Excel 5-7 (*.xls) |
| ImportFilter | REG_SZ | String | Microsoft Excel (*.xls) |
| CanLink | REG_BINARY | Binary | 01 |
| OneTablePerFile | REG_BINARY | Binary | 00 |
| IsamType | REG_DWORD | DWORD | 1 |
| IndexDialog | REG_BINARY | Binary | 00 |
| CreateDBOnExport | REG_BINARY | Binary | 01 |
| ResultTextImport | REG_SZ | String | Import data from the external file into the current database. Changing data in the current database will not change data in the external file. |
| ResultTextLink | REG_SZ | String | Create a table in the current database that is linked to the external file. Changing data in the current database will change data in the external file. |
| ResultTextExport | REG_SZ | String | Export data from the current database into a Microsoft Excel 5.0 file. This process will overwrite the data if exported to an existing file. |
The Jet\3.5\ISAM Formats\Excel 8.0 folder contains the following entries, which apply to Microsoft Excel 97.
Entry name |
Windows NT 3.51 type |
Windows 95 and Windows NT 4.0 type |
Value |
| Engine | REG_SZ | String | Excel |
| ExportFilter | REG_SZ | String | Microsoft Excel 97 |
| CanLink | REG_BINARY | Binary | 01 |
| OneTablePerFile | REG_BINARY | Binary | 00 |
| IsamType | REG_DWORD | DWORD | 1 |
| IndexDialog | REG_BINARY | Binary | 00 |
| CreateDBOnExport | REG_BINARY | Binary | 01 |
| ResultTextExport | REG_SZ | String | Export data from the current database into a Microsoft Excel 97 file. This process will overwrite the data if exported to an existing file. |
Note When you change Windows Registry settings, you must exit and then restart the database engine for the new settings to take effect.