Importing Excel spreadsheet into Acces

  • Thread starter Thread starter firebird9
  • Start date Start date
F

firebird9

This copy of Access 2003 does not appear to have the 'Import Spreadsheet
Wizard.' Am I missing something, or what can I do to import from Excel?
 
firebird9 said:
This copy of Access 2003 does not appear to have the 'Import Spreadsheet
Wizard.' Am I missing something, or what can I do to import from Excel?
Click to expand...


I think you're missing something. What happens when you click File -> Get
External Data -> Import..., and choose Files of type: Microsoft Excel
(*.xls) ?

You can use VBA code to call the DoCmd.TransferSpreadsheet method, but you
should not have to.
 
Back
Top