I've been crawling the web but I can't seem to pin an answer down for my situation...
Currently I use an ADODB.Recordset to gather info from a Sybase connection
with the ADO recordset, I then loop through each record and perform an insert.
Do while Adodata.eof = false
docmd.runsql "INSERT INTO tblName VALUES '" & adoddata("fieldname") & "','" ...
adodata.movenext
Loop
Is there a faster way to take the ADO recordset and insert it into the linked table on Access?
Currently I use an ADODB.Recordset to gather info from a Sybase connection
with the ADO recordset, I then loop through each record and perform an insert.
Do while Adodata.eof = false
docmd.runsql "INSERT INTO tblName VALUES '" & adoddata("fieldname") & "','" ...
adodata.movenext
Loop
Is there a faster way to take the ADO recordset and insert it into the linked table on Access?