By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,601 Members | 989 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,601 IT Pros & Developers. It's quick & easy.

Batch insert in MSAccess XP

P: 2

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 OleDbDataAdapter 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?

Mar 20 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,359
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.
Mar 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.