Importing excel spreadsheet into two tables at the same time

  • Thread starter Thread starter Shaheed
  • Start date Start date
S

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
 
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.
 
Back
Top