Importing and keeping tables

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

Guest

Hi there
I wish to be able to import from excel into a table. Now the dilema that i
am facing is that i receive a excel sheet from a company head office every
day, which contains primary key fields.
Now when they send this information, the primary key is still the same, but
the pricing in the other fields changes.
Is there a way where i can import the data from excel, where it only UPDATES
fields that either require to be updated, or REPLACE the fields that have
changed. I just find it hard to import it because i find that i have to
delete the records before i can update the others.

Help is needed!
Thank you very much in advance
 

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

Importing SSNs from Excel into access 2007 and using as primary ke 1
Import Excel worksheet into a lookup 2
Import Error 1
Access import from Excel - Append & Update simultaneously 1
Import problems from Excel 2000 - Access 2000 3
Importing and modifying exisiting primary key data 3
Importing Text Files Into Access 1
Import excel dat to update and add new records 1

Back
Top