Batch insert in MSAccess XP

[vikramrawal]

hi,

I am using C# with MSAccess XP. I need to insert bulk of records around 10000 in MSAccess.
So obviously if I inserts each record individually then it will take lot of time.
By using OleDbDataAdapte r and setting its UpdateBatchSize property we can insert bulk of records in single trip to database but this property is not supported for MSAccess because I think MSAccess not support batch update.
So is there any other way to achive this?

Regards,
Vikram

[Rabbit]

What's the format of the data? If it's in a table format that Access can accept you can just use an append query. If you have to build each record individually then you can use a loop.