Hi All,

I'm using DAO recordset to insert records into my MS ACCESS database using VB6.

In my code, we are placing records into database using below code:

Dim oRecordset As Recordset
oRecordset.AddNew()

//Filling all fields(around 100) with data using below statement
//Is there any better way to improve this code
oRecordset.Fields("fieldname") = fielddata

oRecordset.update()
oRecordset.Close()

Actually, we are placing lakhs of data into DB using above code continusely and only one record is available at a time.

Can any one suggest any better way to do this task. Its taking so much time... This is urgent requirement!!!!Pls  help.

Thanks,
Surya

____________________________
surya satya

Hi,
Your syntax is correct and only using Access it's probably about as good as you are going to get.

Some things you can do.
Dont keep closing the recordset between calls to "addnew" will help.
use updatebatch not update

Alternatively,
I would recommend using Text importing in access to bulk import the data, then use queries to mess around with it (formatting, etc.) - much much quicker

Hope this helps,
Kieron


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)