creating one-to-many linked tables

[Emmweb]

I have an excel spreadsheet with expense data on it. There is a separate line
for each detail transaction. However, several detail transactions have many
fields the same as they were all a single voucher.

What I'd like to do is import this data into a database, with two tables.
One with voucher data and one with the linked detail data. One voucher record
could be linked to multiple detail records.

Is there a quick and easy way to have access do this for me, or a particular
process I can use to ensure all the data gets imported and is correctly
linked? If I can get this to work, I have a number of other Excel sheets I'd
like to do similarly. I started out just trying to import and split the data
manually, but a year's worth of data is pretty intimidating! Thanks!
Emma

 

[KARL DEWEY]

First make a Voucher table with fields for all common information of the
voucher -- VoucherID, DateOpen, DateClose, etc. Make the VoucherID a ket
field.
Next make a Item table with the VoucherID and all of the rest of the fields.
Use the Menu - Tools - Relationship and link Voucher table to Item table as
a one-to-many.
Copy and paste-append the columns of voucher information and ignore message
that says cannot append all as there are duplicates.
Copy and paste-append the columns of item information.