Worksheet FilterID
The following table shows the file extensions and the appropriate FilterId values for worksheets.
Extension |
File Description |
Import Options Links |
FilterId Values |
.ACCDB |
"accdb" |
||
.BLN |
"blnw" |
||
.BNA |
"bnaw" |
||
.DAT |
"dat" |
||
.DBF |
"dbf" |
||
.LAS |
"lidarw" |
||
.MDB |
"mdb" |
||
.SLK |
"slk" |
||
.TXT |
"txt" |
||
.XLS |
"xls" |
||
.XLSX |
"xlsx" |
||
.XLSM |
"xlsm" |
Remarks
- FilterId is required if no recognized file extension is used in FileName, or if the file extension supplied can be used by more than one file format.
- FilterId is case-sensitive. File extensions are case-insensitive.
- If FilterId is used the file extension is optional.