Combine Tables Into One

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

Guest

I'm dealing with "Usage Reports" (Qty of sales for various Items) for
multiple customers.

Software that I'm using allows me to get a cutomers usage in a csv file.

I want to combine the data from about 40 customers into one database but I
don't want to loose any data. Part Numbers will be common amongst multiple
tables but qty orderd will be different.

What I'm looking to do is essentially a "copy and paste" of all data from
multiple tables into one table.

Any help is appreciated.
 
I'm dealing with "Usage Reports" (Qty of sales for various Items) for
multiple customers.

Software that I'm using allows me to get a cutomers usage in a csv file.

I want to combine the data from about 40 customers into one database but I
don't want to loose any data. Part Numbers will be common amongst multiple
tables but qty orderd will be different.

What I'm looking to do is essentially a "copy and paste" of all data from
multiple tables into one table.

Any help is appreciated.
Click to expand...

APPEND queries will do this for you, and/or a UNION query.

Do you have a properly normalized database set up - one with a table
of Customers with a unique customerID, a table of Parts with a PartNo,
etc.? Or are you just trying to deal with the (apparently
spreadsheet-like) csv files?

John W. Vinson[MVP]
 
Back
Top