I'm using ADODB to take a complete recordset from an external source (QuickBooks) and dump it into a table.
I just cleared the existing table with
REC.Open("Delete * From Employees", cn, CursorTypeEnum.adOpenDynamic, LockTypeEnum.adLockOptimistic)
I want to insert all the records from recordset into the employees table.
I tried the insert into...... but couldn't get all the records recognized.