Importing Help

[Cybersurfer]

I have a database with four tables created from an Excel Spreadsheet. I get
a new report weekly in Excel that I would like to import to the tables. How
do I set up an append query to bring this data in and update the four
tables?

Parent Child
Table Name Key Table Name Key
Element ID Capacity Element
ID
Site ID Element Site
ID
Market ID Site
Market ID

Any help you can give or reference to articles would be appreciated!!

Thanks,

Rich

"Superior Attitude, Superior State of Mind"

 

[[MVP] S.Clark]

I like to import the data into a temp table. Then use queries to write the
data to the actual table. You may be able to simply link the excel table to
the access database, then run the query from there.

As far as how do you setup an append query... Create a new query, and change
it to be an Append query. Select the destination table.

 

[Cybersurfer]

I do have the table linked and have setup the append query. It returns
errors. I thought maybe someone had links to something I could read up on.
I have used append queries a lot just never putting the data accross tables.

Thanks,

Rich