update table from excel file

[Pierkes]

Hi,

I have a table called tbl_adv
In the table a have a primary key called nr_adv
I also have an autonumber field called ID_adv (not the primary key)

I have an excel file called excel_adv
In excel i have the same fields as in de table.

Now, the primary key in the tbl_adv will never change. In excel i also have the same key.

However, the other fields from each record may change over time due to user input.

Now i want the tbl_adv records updated from the excel file.

I tried to use the append import function but that only get new records into the tbl_adv and does not change existing records.

How can i update the existing records in the database with fields in the excel file ?

Any help would be greatly appreciated

Thanks,
Pierkes

[twinnyfo]

An append query will always add records. You can link the spreadsheet and use it as a table, join it with the table in your query and then use an update query to update the table.