- Joined
- Apr 18, 2007
- Messages
- 1
- Reaction score
- 0
I have an access database in which I export a copy in excel form to workmates so they can add and update info contained within.
I want to import the changes they have made to my access database, but when I try to do this using the import function it won't change any rows which already exist,. I says this is due to the primary keys. The primary keys will never change but all the other info for each row will.
All i want is for it to update using the changes made in the excel files
I want to import the changes they have made to my access database, but when I try to do this using the import function it won't change any rows which already exist,. I says this is due to the primary keys. The primary keys will never change but all the other info for each row will.
All i want is for it to update using the changes made in the excel files