MS Access 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.

[jamieakers]

  On 16/04/2015 at 21:55, Michael Lacey said:

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.

 

I think what you're trying to do is referred to as "UPSERT" in TSQL terminology.  I've not done this for a while, but I believe you're looking at doing something similar to what is discussed here: http://stackoverflow.com/questions/6199417/upserting-in-ms-access