Batch importing data for new and updated records.

[Timothy Lange]

Hi, I'm an Access newbie, I have an Access DB with multiple tables for our
inventory of 14,000 records. Location, Serial#, Model, and Brand tables
linked, others too, but not relevant for this.

I need to setup a way to import batches of new inventory. Around 200 records
at a time. I cannot import/append to one table as my import data has the
actual location names, serial#, model names, and brand names. The serial#
table just has numbers in it for the location, model, and brand information
which links to other tablets that have the actual info.

Can you point me to an example for importing and appending data like this?

I also need a way to import batches of equipment moves, that different
locations and serial numbers. Up to 200 at a time. I suspect once I know how
to do the first task mentioned here, I will be able to figure this one out.

I'm looking for examples, should be able to figure it out from there.

Thanks,

Tim Lange
West Lafayette, IN USA
(Go Boilers!)

 

[Douglas J. Steele]

Import the data into a temporary table.

Run a query that join your temporary table to the tables that can translate
from the names to the Ids.

Use that query to populate your real table.