vba code to insert a field value from an access table into a sql table based on criteria
Posted on 2011-05-13
I have an access table called "ReceiverNoTableFinal" and a sql table called "iitdata". The ReceiverNoTableFinal has three fields called "IITReportNo (no duplicates)", "IITDate", and "ReceiverNo (text)".
The "iitdata" table has the same three fields and additional other fields. The "iitdata" table records are uniquely identified by the field "IITReportNo (no duplicates)".
What I need help is to use VBA to insert values of "ReceiverNo" FROM the "ReceiverNoTableFinal" INTO the "ReceiverNo" field of the "iitdata" table wherever the IITReportNo values MATCH in both tables. Also the insertion has to occur IF the ReceiverNo field is null in the "iitdata" table. Could really use expert help with this.