Hi,
I have a table of data in access with circa 20 fields and perhaps 1000 rows of data. This data has been replicated into excel files which a Mobile team are validating the data in the field. I will receive 10 excel files back from the team which needs to update my table.
What is the best way to update my table? I don’t wish to go through creating an update query for each file I get per week as the only way i know how to do this is rather longwinded?
I am hoping and i have no doubt there is easy way to doing this.
Thank you for reading
Regards,
GC1
Bookmarks