Import New Changed Records - Import New, Changed Records in Microsoft Access


	Back to Import New, Changed Records Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Import New Changed Records

Jamour Burns

4 years ago

I have a problem, I would like my users to be able to make changes to any column in the excel sheet that is linked to Access and it will update using the update query to my table. Is there a way that I can the update query to detect any changes in the data and import it?

Adam Schwanz @Reply

4 years ago

Not that I know of, I'm not as keen on excel VBA if you could program it to do it. If you use the table frequently inside access you wouldn't want it running random update queries either while your users are using the data. You're going to run into some errors.

What does the excel sheet do? It seems to me like it would be easier to just move the excel sheet into access instead and stop using the excel sheet. If you HAD to have an excel sheet for something like sending to someone who only accepts excel, you could easily just grab the most current information from access and export it to an excel file to send out.

	Richard Rost @Reply 4 years ago
Not easily, no. Like Adam said that would require some coding to compare the data.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Import New, Changed Records.

Next Unseen

New Feature: Comment Live View