How to convert existing Excel List into a table in Access?

A

anna

Is it possible to convert existing Excel List into a table in Access database
in 2003 Excel I know it was possible in 2002 version through AccessLinks ?
 
D

Debra Dalgleish

You can import the Excel list into Access, and use it there as a table.

In Access, choose File>Get External Data>Import
In the Files of Type dropdown, at the bottom of the dialog box, choose
Microsoft Excel
Locate and select your Excel file, and click Import
Step through the Import Wizard, to complete the import.
 
A

anna

Thanks Debra it is exacly what I m doing I just wondered about that
AccessLinks which were availible through add-in program in 2002 version
 

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

Top