Combine Tables Into One

[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.

 

[CyberDwarf]

Have a look at "SELECT INTO" queries...

HTH

Steve

 

[John Vinson]

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.

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]