Inserting records from recordset taking a long time??

[daddypost]

Is there a quicker way of getting records into a table than inserting a line, rs.movenext, insert a line, rs.move next....

I'm retrieving records from a sybase server in a recordset. I need to throw these in an access table. I'm running a cmd.execute on an insert sql statement. Then doing rs.movenext and repeating. Some of the tables i'm hitting have 100,000 records +. IF there is a quicker way, would you let me know.
Thanks

 

[genomon]

Dim strSQL as string

strSQL = "INSERT INTO accesstable SELECT * FROM sybasetbl"
doCmd.RunSQL strSQL

Unless I misunderstood you, this should work.
Good luck!

I have great faith in fools; self-confidence my friends call it.
-Poe