Importing Excel spreadsheet into Acces

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?
 
D

Dirk Goldgar

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Subscript out of range when importing into access 2010 from excel 0
Import Excel Spreadsheet 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Spreadsheet missing field 8
Data type on import wizard not active 12
Error Importing Excel Spreadsheet into Access 1
Importing Excel Spreadsheet into Access 1
Import data 1

Top