Updating Master Table

[wchernock]

I have a macro that imports data into a RAWProject table. I would like to write a routine that reads through the RAWProject table, checks to see if the project# (key) exists in the MasterProject table. If it does not exist, append the project record to the MasterProject Table. It it exists, update the project info in the MasterProject table.


This sounds really easy but I do not know where to begin in writing a FOR loop to cycle through the RawProject table.


Does anyone have an example.

 

[pbaldy]

Before bothering with code, you might see if this will work for you:

http://support.microsoft.com/kb/208870/en-us

 

[wchernock]

Thanks for the KB article. I'll give it a try and let you know how it works.

 

[wchernock]

Worked a little hokie. The logic seems backwards but I seem to have it figured out. Thanks. That saved me a ton of programming logic.