Initializing the Lotus Driver

Office 2010

When you install the Lotus database driver, the Setup program writes a set of default values to the Microsoft® Windows® Registry in the Engines and ISAM Formats subkeys. You should not modify these settings directly; use the setup program for your application to add, remove, or change these settings. The following sections describe initialization and ISAM Format settings for the Lotus database driver.

The Access Connectivity Engine\Engines\Lotus folder includes initialization settings for the Acelts.dll driver, used for external access to Lotus spreadsheets. Typical settings for the entries under this heading are shown in the following example.

win32=<path>\ACELTS.DLL 

TypeGuessRows=8 

ImportMixedTypes=Text 

AppendBlankRows=4 

FirstRowHasNames=Yes

The Microsoft Access database engine uses the Lotus folder entries as follows.

Entry

Description

win32

The location of msltus40.dll. The full path is determined at the time of installation. Values are of type REG_SZ.

TypeGuessRows

The number of rows to be checked for the data type. The data type is determined based on the most frequently found data type in the selection. If there is a tie, the data type is determined in the following order: Number, Currency, Date, Text, Long Text. If data is encountered that does not match the data type guessed for the column, it is returned as a Null value. On import, if a column has mixed data types, the entire column will be converted according to the ImportMixedTypes setting. The default number of rows to be checked is 8. Values are of type REG_DWORD.

ImportMixedTypes

Can be set to MajorityType or Text. If set to MajorityType, columns of mixed data types will be cast to the predominate data type on import. If set to Text, columns of mixed data types will be cast to Text on import. The default is Text. Values are of type REG_SZ.

AppendBlankRows

The number of blank rows to be appended to the end of a WK1 worksheet before new data is added. For example, if AppendBlankRows is set to 4, the Microsoft Access database engine will append 4 blank rows to the end of the worksheet before appending rows that contain data. Integer values for this setting can range from 0 to 16; the default is 01 (one additional row appended). Values are of type REG_DWORD.

FirstRowHasNames

A binary value that indicates whether the first row of the table contains column names. A value of 01 indicates that, during import, column names are taken from the first row. A value of 00 indicates no column names in the first row; column names appear as F1, F2, F3, and so on. The default is 01. Values are of type REG_BINARY.

The Access Connectivity Engine\ISAM Formats\Lotus WK1 folder contains the following entries.

Entry name

Type

Value

Engine

REG_SZ

Lotus

ExportFilter

REG_SZ

Lotus 1-2-3 WK1 (*.wk1)

ImportFilter

REG_SZ

Lotus 1-2-3 (*.wk* )

CanLink

REG_BINARY

00

OneTablePerFile

REG_BINARY

00

IsamType

REG_DWORD

1

IndexDialog

REG_BINARY

00

CreateDBOnExport

REG_BINARY

01

ResultTextImport

REG_SZ

Import data from the external file into the current database. Changing data in the current database will not change data in the external file.

ResultTextExport

REG_SZ

Export data from the current database into a Lotus 1-2-3 Version 2 file. This process will overwrite the data if exported to an existing file.

SupportsLongNames

REG_BINARY

01

The Access Connectivity Engine\ISAM Formats\Lotus WK3 folder contains the following entries.

Entry name

Type

Value

Engine

REG_SZ

Lotus

ExportFilter

REG_SZ

Lotus 1-2-3 WK3 (*.wk3)

CanLink

REG_BINARY

00

OneTablePerFile

REG_BINARY

00

IsamType

REG_DWORD

1

IndexDialog

REG_BINARY

00

CreateDBOnExport

REG_BINARY

01

ResultTextExport

REG_SZ

Export data from the current database into a Lotus 1-2-3 Version 3 file. This process will overwrite the data if exported to an existing file.

SupportsLongNames

REG_BINARY

01

The Access Connectivity Engine\ISAM Formats\Lotus WK4 folder contains the following entries.

Entry name

Type

Value

Engine

REG_SZ

Lotus

CanLink

REG_BINARY

00

OneTablePerFile

REG_BINARY

00

IsamType

REG_DWORD

1

IndexDialog

REG_BINARY

00

CreateDBOnExport

REG_BINARY

01

SupportsLongNames

REG_BINARY

01

The Access Connectivity Engine\ISAM Formats\Lotus WJ2 folder contains the following entries.

Entry name

Type

Value

Engine

REG_SZ

Lotus

ExportFilter

REG_SZ

Lotus 1-2-3 WJ2 (*.wj2)

ImportFilter

REG_SZ

Lotus 1-2-3/DOS (*.wj* )

CanLink

REG_BINARY

00

OneTablePerFile

REG_BINARY

00

IsamType

REG_DWORD

1

IndexDialog

REG_BINARY

00

CreateDBOnExport

REG_BINARY

01

ResultTextExport

REG_SZ

Export data from the current database into a Lotus 1-2-3 Version 2 file. This process will overwrite the data if exported to an existing file.

SupportsLongNames

REG_BINARY

01

The Access Connectivity Engine\ISAM Formats\Lotus WJ3 folder contains the following entries.

Entry name

Type

Value

Engine

REG_SZ

Lotus

CanLink

REG_BINARY

00

OneTablePerFile

REG_BINARY

00

IsamType

REG_DWORD

1

IndexDialog

REG_BINARY

00

CreateDBOnExport

REG_BINARY

01

SupportsLongNames

REG_BINARY

01

Note Note

When you change Windows Registry settings, you must exit and then restart the database engine for the new settings to take effect.

Show: