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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Excel Column To Access with Criteria. Help 2
Import spreadsheet with modified date 1
Importing Excel Spreadsheet into Access 6
Import Excel 2010 table into Access 2010 - not listed as range 1
Comparing Prices in two excel sheets 3
Technique for Updating Part Master 5
Data Validation 1
Amalgamating similar tables 1

Back
Top