How to import Excel Spreadsheet

  • Thread starter Thread starter Shari
  • Start date Start date
Shari,
You can use the import wizard.
A2003 File | Get External Data | Import

Jeanette Cunningham
 
Hi Shari,

Does the table already exist? If so, then it's a little tricky at times.

Sometimes its easier to import the spreadsheet into a new table using the
Get External Data process and then deal with it from that point.

The import steps depend on what version of Access you are using - its
realtively easy using Access 2007 External Data tab, click on Excel

In Access 2000/XP/2003 it's more complicated.
Select the File Menu, Get External Data, Import then click on the bottom row
of the window where it says Files of type. You will probably see a default
of Microsoft Office Access. If you press M, the next one up is Microsoft
Excel (*.xls) If that doesn't work, you will have to scroll through the
list and find Microsoft Excel (*.xls) - and select it. Now you navigate to
the folder containing your Excel workbook and select the appropriate file.

Hope this help...
Gordon
 
Also, Shari....presume you are not wanting to do this in VBA, which of course
would result in different answers!?

Patk
 
Back
Top