Import SpreadSheet Specification

[ions]

Dear Access Experts

I am trying to import an Excel file using

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportSpecification", "FileName", True

however, when I run the spreadsheet import wizard I don't see an option for saving the specification.

When I run the 'text file' wizard I do have the option of saving the specification. I am using Access 2002 and 2003 and I have not found the option in either for spreadsheets.

How can I define the import specification for excel spreadsheets?

Thanks so much

Peter.

 

[ions]

I noticed that the csv (comma seprated excel file) is among the .txt suffixes for file types.

Should I save my Excel (.xls) sheet to a csv? and then import?

Thanks.

 

[ions]

No Responses?

 

[expat1000]

For anyone else searching on this..

DoCmd.RunSavedImportExport but the import file name has to be static - can't change it runtime.