Hello friends..please help me
I have two identical Tables in my Database (Access) Table 1.Salup , Table 2.Salup1 .
All the fields are identical
My problem is:- I want to copy/append
1. All the records
2. selected Records agreeing certain criteria(eg."Sex=Male") From Table 1 to Table 2. through VB6 code.I started my coding as follows,But I could not succed with it.
Set ACRS = New ADODB.Recordset
If ACRS.State = adStateOpen Then ACRS.Close ACRS.Open "SELECT * FROM Salup1", CN, adOpenStatic, adLockOptimistic