new user - importing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

not sure if I should be here or in new users:

I have 5 tables in excel to export to access 2003 into one (new) database.
Can you help me or direct me to an article that might tell me what to do to
import and link tables 2-5 to the primary key in table 1.

Thanks
Rita
 
Hi Rita,

Open Access as a new blank database

Use the menus File/Get External Data/Import and select your data.
When all tables are in, go to design mode for each table and set the unique
key.
If Auto Join is enabled, the tables will link automatically when used in
queries.

Regards
Col
 
Back
Top