Updating Access table with Excel 2000

[abbyanu]

Hi

I would like to update an Access table from Excel 2000, and ensure that there are no duplicate records. The access table has some extra fields that the excel worksheet does not have.

I wish to update the access table and leave these extra fields intact when I import the excel data. However, if the excel data has any new records, I wish these records to be appended into the access table as well.

How can I do this?

Many thanks.

 

[abbyanu]

I have done accomplished part of this, by importing the excel data into a temporary access table, [TempData]. This has 6 fields : F1, F2, F3, F4, F5, F6, with the primary field being F1.

The table I wish to update, [Products], has 9 fields: G1 - G9, with the primary field being G1. G1-G6 correspond with F1-F6.

I wish to UPDATE the [Products] table with the 6 fields from [TempData] WHERE [Products].ProdNo = [TempData].F1. Any extra records in [TempData] should be appended as new records in [Products].

After the update, I then wish to delete all the records in [TempData], leaving the table blank.

Any ideas? I appreciate your assistance.

Peace,
AbbyAnu.