I have to import about 300K number of records into an access database. I had unloaded VB3.0 from my
machine and have recently reloaded it.
1) Wasn't there something I had to do to get VB3.0 to read/write ACCESS2.0?
2) I have programmed my VB application to create a database and table. My question is what is the easiest
means to put these 300K records into the database?
Is there a speed hit if I chose table over dynaset? This is a single user database.
Right now it looks like I need to
For x = 1 to 300000
MyTable("Field1") = value
MyTable("Field2") = value
MyTable("Field3") = value
MyTable("Field4") = value
MyTable("Field5") = value
This would appear to be harddrive intensive and I was hoping for a more efficient method.
Sorry if this is in the wrong news group but I know what ..vb.database.odbc is and don't know what DAO or
RDO are so was not sure the appropriate group to post..