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.