Update the existing Table

[dhen21dx]

Hello,

I need advise on how i can do the update of existing Table, I have the "Unique Key" from the existing table, and i need to upload the changes using excel file to (same on table) on the existing Table. Please advise.
Thanks

 

[ranman256]

store the xl file to the same place everytime , say: c:\temp\file2import.xlsx
link the file as an external table (do this once)
make your update query using this table.

then the steps are
1. save xl file to c:\temp\file2import.xlsx
2. run update query
done

 

[dhen21dx]

is the update query in the form of VBA?

 

[Joe4]

is the update query in the form of VBA?

Not sure what you are asking.
You can run an update query by VBA, but you don't necessarily have to.