There are two tables, one with a "master record", an initial set of records. The other is a table that is constantly updated through a VBA script that imports a .csv every 10 minutes.
What I want is the query to check every field in the import table and compare it to all records and fields in the master table. I then want it to append any changed fields to the master table for permanent record.
I have been fussing and fiddling with this for a week now, rebuilt this query in VBA, SQL and query design wizard. Unfortunately my knowledge in all of these is limited and I always bit a roadblock. Can anyone tell me what I am up against and point me in the right direction with an example of how they would do this. Thank you very much.
Question
Michael Lacey
Hi,
I have a database that I need to run a query on.
There are two tables, one with a "master record", an initial set of records. The other is a table that is constantly updated through a VBA script that imports a .csv every 10 minutes.
What I want is the query to check every field in the import table and compare it to all records and fields in the master table. I then want it to append any changed fields to the master table for permanent record.
I have been fussing and fiddling with this for a week now, rebuilt this query in VBA, SQL and query design wizard. Unfortunately my knowledge in all of these is limited and I always bit a roadblock. Can anyone tell me what I am up against and point me in the right direction with an example of how they would do this. Thank you very much.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts