• 0

MS Access Question


Question

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

  • 0

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

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.