Importing excel spreadsheet into two tables at the same time

[Shaheed]

Hi,

I am trying to design a database using MS Access 2007 that stores
product and price information.

All my suppliers send me a spreadsheet on a monthly basis with the
following fields:

1. Product Code
2. Product
3. Price

Since I want to store all sorts of information about products, I want
to store product information in a separate table and price information
in another. I know I can manually clean up the spreadsheet every month
by putting a separate sheet for product information and a separate one
for price information but that's very labour intensive and repetitive.
Is there another way to accomplish what I want to by for example
importing a couple of fields into one table and the rest of the fields
into another?

Thanks

Shaheed Fazal

 

[Ken Snell]

Import the spreadsheet into an interim table. Then use append queries to
copy the fields to the first table, then other fields to the second table.