Microsoft Access Forum

Access Forum

Determine Updates in Import Upload Images Link
Kishore Singh
4 months 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
4 months 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
4 months 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
4 months ago

Never Mind, I have been able to develop a script to do this.

Richard Rost
4 months 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, below.

Back to Access Forum