Importing Data from a Spreadsheet to Existing Multiple Tables

[skilche1]

First off, its been a long time since I have been here (since sometime in 2003 LOL), partly because I didn't have to create a new db in a while. Now, I have been handed a project and come across something new.

OK, here is what I want to do. I would like to be able to dump data from an Excel file into existing Access tables (two to be more specific). Now, I also have relating tables that add data into certain fields. I tried using a query to try to group data ad hopeful able to dump data through the query. I noticed that I couldn't import data through a query. Just for kicks, I tried to pull data through table and noticed that I can only create a new table, not able to update and existing table.

How would I go about performing this task? I have never attempted anything in the past.

Thank you in advance for your considered help,

Steve

 

[statsman]

I believe you have answered your own question.

Import the excel spreadsheet. Be sure to put the names of the fields that are in you Access table in the top row of the spreadsheet first. Makes life easier when you go to step 2.

Use an append query to add the records to your table.

 

[jsanders]

The problem you are having with using a linked spreadsheets comes from the fact that a spreadsheet is a "flat" file and as such has no index. In a query, ALL tables must be updatable in order for the query to be updatable. It doesn't matter which table in the join is actually being updated. On a further note, due to a lawsuit settled last year (Microsoft lost), linked spreadsheets are no longer updatable.

What?
What kind of lawsuit can keep a table from being updatable?