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.
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.