vba code to insert a field value from an access table into a sql table based on criteria
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER