Load data from a flat file to a linked file

E

Elise

I have a many to many relationship. The tables are:

Student Table
Student Id <Primary Key> (AutoNumber)
Linking Table
Link Id
Link Student Id < Primary Key> (Combined)
Link Parent Id <Primary Key>
Parent Table
Parent Id <Primary Key> (AutoNumber)

I have data imported from excel in a flat table.

How can I load this data to my Student, Link, and Parent tables?
 
P

Pat Hartman\(MVP\)

You'll need to load the student table and the parent table (you could store
students and parents in the same table if you wanted since in some
situations, parents can also be students). Then you need to create a query
that joins the spreadsheet to both of the new tables on the old "keys" or
whatever set of fields will be unique. You would then turn that query into
an append query and append the primary keys from both joined tables into the
linking table.

Once this is done, check your work by trying to recreate the spreadsheet by
joining the three new tables.
 

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