By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,345 Members | 2,404 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,345 IT Pros & Developers. It's quick & easy.

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

P: 26
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.
Sep 25 '06 #1
Share this Question
Share on Google+
2 Replies


PEB
Expert 100+
P: 1,418
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
Sep 25 '06 #2

P: 26
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
Sep 25 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.