Determine Updates in Import - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Determine Updates in Import

Kishore Singh

4 years ago

Hi All,

I have a few tables in MS Access with 40 odd fields in each table. Every week I receive excel files that contains the updates over the last one week. I am working on capturing all the changes that has come in recent excel files and capture them in a change log table. During Import, Is there a way to determine all the fields that has a change and capture them in the change log.

I have gone through the readily available video but that works with only predefined fields while I want to capture every single change that has come in any of these 40 fields.

Appreciate if someone can guide me with a way that can easily be applied. Please note I do have some knowledge around VBA code.

Thanks in advance!
Kishore Singh

	Richard Rost @Reply 4 years ago
This technique would work, although you'd have to check for changes with each field: Import Changes The only alternative would be to load the imported data into a new table and use a Recordset loop to compare each record in table 1 with its corresponding record in table 2.

	Kishore Singh OP @Reply 4 years ago
Thanks Richard for the reply. When we use recordset to loop through. We would need to create 2 recordsets for each table. Is nt it? Sorry if I understood it wrong. If possible would you be able able to give a hint.

	Kishore Singh OP @Reply 4 years ago
Never Mind, I have been able to develop a script to do this.

	Richard Rost @Reply 4 years ago
Glad you figured it out. If you want to learn more about recordsets, see Developer 16.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View