Append Data Using VBA With Criteria
Posted on 2002-07-29
Hello all. I would like to know if there is a way to append data from one table to another using VBA with a criteria?
I need to get data from table “tsub_Issue_To_ICWG” and Append it to “tsub_Boeing_Issue_To_ICWG”
This is what my VBA code looks like so far:
rstAppBoeingIssueToICWG.Open "SELECT * FROM tsub_Issue_To_ICWG WHERE num_Foreign_Issue =" & intPrimaryKeyICWG, cnn, adOpenKeyset, adLockOptimistic
I know how to do the With……With End….just looking for a more efficient way