AcSpreadSheetType Enumeration

Access Developer Reference

Used with the TransferSpreadsheet method to specify the type of spreadsheet to import from, export to, or link to.

Name Value Description
acSpreadsheetTypeExcel3 0 Microsoft Excel 3.0 format
acSpreadsheetTypeExcel4 6 Microsoft Excel 4.0 format
acSpreadsheetTypeExcel5 5 Microsoft Excel 5.0 format
acSpreadsheetTypeExcel7 5 Microsoft Excel 95 format
acSpreadsheetTypeExcel8 8 Microsoft Excel 97 format
acSpreadsheetTypeExcel9 8 Microsoft Excel 2000 format
acSpreadsheetTypeLotusWJ2 4 Japanese version only
acSpreadsheetTypeLotusWK1 2 Lotus 1-2-3 WK1 format
acSpreadsheetTypeLotusWK3 3 Lotus 1-2-3 WK3 format
acSpreadsheetTypeLotusWK4 7 Lotus 1-2-3 WK4 format