default to xls

[mcourter]

can i default the file type to xls using this code?

DoCmd.RunCommand acCmdImport

tia,

mcnewsxp

 

[Guest]

Hi,
use the transferspreadsheet method instead!
Syntax:

TransferSpreadsheet(TransferType, SpreadsheetType, TableName, FileName,
HasFieldNames, Range, UseOA)

HTH
Good luck

 

[mcourter]

they won't always be importing spreadsheets, just mostly.