Import Excel to Access and update the respective db fields with the excel value

[ruthboaz]

Hi,

I am exporting a table with data to an excel file.. Some fields are empty in the exported file while the others and the key field, has values.

The empty field(s) in excel, will be entered with values by another department.

I require to update the access db from the updated excel fields to the respective fields in the database..

While using import from the file menu, I see that the information is append the table..

With link to excel, I see the data is still in the excel..

I want the key fields in the excel and the db table to match and do the update to the respective fields in the access table..

Pls assist.

Thanks & Regards,
Ruth.

[PEB]

Hi Ruth,

You have the right direction!

You do a Link to the respective Excel file and then u go in query designer
There you choose the table u want to update and your Excel file

Maybe u have a key and the link must be on this key

From query u choose update query

Dbl click on your Field that u want to update
In the row Update to type the name of your Excel Field but with
[] between

:)

Best regards

[ruthboaz]

Hi,

Thank You for the help.
Just to the dot, PEB.

Best Regards,
Ruth.

Hi Ruth,

You have the right direction!

You do a Link to the respective Excel file and then u go in query designer
There you choose the table u want to update and your Excel file

Maybe u have a key and the link must be on this key

From query u choose update query

Dbl click on your Field that u want to update
In the row Update to type the name of your Excel Field but with
[] between

:)

Best regards