Db Sql Insert

[dragonsbb16]

I have a question.....i am uing Access as the back-end database of a VB6 Front end app.
Basically i have a recordset with about 300K records....i currently Insert 1 row at a time....which takes ALOT of time.....is there a faster way to do the insert? i saw some things on the internet about a BULK insert....but it sounds like it is only with SQL Server or ORACLE. Please let me know what you think.

 

[Dreamweaver]

Where Does the Original Data come from IE Excel, Another Access DB or Web page\DB?

Mick

 

[dragonsbb16]

data

sorry forgot to mention that......the recordset is filled from another Access Table. Also, both Table structures are the same.