Export (0) Print
Expand All
Expand Minimize

AcSpreadSheetType Enumeration (Access)

Published: July 16, 2012

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

Community Additions

ADD
Show:
© 2014 Microsoft