splitting tables w an update or append query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

first, is it possible?

i have a set of tables that i need to take the data and split it into tabels
that store the same information with out redundancy. the problem goes like
this.

i have 5 machines in a country, each in a different city, each is of a model
that may be the same, each with parts that make up the entire machine.
currently all the data is in 5 excel tables which i can import easily or link
to the database i want to create.

each part used to make an individual machine can be slightly different from
a machine of the same model. for instance the wheel on one machine might be
different from the wheels on another. so i need to list both of these parts.
but yet the machine is the same.

i have created all the tables i want the data to go into, but i need to put
data into multiple tables. for instance i have a parts list table and a unit
list table. i need to take all the part data and put it into the table for
it, but at the same time i need the query to match that to the data listing
the individual machines.

is there a way to do this? i love update queries, but those will only add
the data to one table at a time.

if i need to explain it more please let me know.
 
check out the book "the access developer's handbook". It's a great book and
has a good chapter on splitting and normalizing tables.
 
Back
Top