Access.2007.VBA.Bibl..

TABLE 10.1

DatabaseType Argument Values for dBASE and Paradox

Database Version DatabaseType Value

dBASE III dBASE III

dBASE IV dBASE IV

dBASE 5 dBASE 5.0

Paradox 3.x Paradox 3.X

Paradox 4.x Paradox 4.X

Paradox 5.x Paradox 5.X

Paradox 7.x Paradox 7.X

Now that the data is in an Access table, you can proceed to work with it as needed.

Importing Spreadsheet Files ....................................................................................

If you have old Lotus 1-2-3 spreadsheet files, you can import data from them into Access tables

using the TransferSpreadsheetmethod, which works much like the TransferText

method, importing all the data from a worksheet. Unlike database files, you can use named

argument values from the AcSpreadSheetTypeenum for spreadsheets of various versions;

these values are listed in Table 10.2.

TABLE 10.2

SpreadsheetType Named Constants for Lotus 1-2-3

Lotus Version SpreadsheetType Named Constants

Lotus WK1 acSpreadsheetTypeLotusWK1

Lotus WK3 acSpreadsheetTypeLotusWK3

Lotus WK4 acSpreadsheetTypeLotusWK4

Lotus WJ2 acSpreadsheetTypeLotusWJ2

Part II Writing VBA Code to Exchange Data between Office Components