how to insert 10000 records once into a access table?

  • Thread starter Thread starter tezheng
  • Start date Start date
what's the fastest way via ADO?
a table with a primary key and two indexes.
Click to expand...

Feel free (no, feel obligated, please) to put your entire question here in
the big white area, rather than putting the most important part in the
Subject line, which some newsreaders may truncate. For other good
suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm.

Where are the 10,000 records coming from?

Why do you limit your question to "via ADO"?

Is your data stored in a Jet (aka Access) database?

Is your application using Access, or some other software/language, as the
"front-end" to your database?

What key and index information is in the 10,000 records? Both?

Larry Linson
Microsoft Access MVP
 
thanks first

all the data are in memory(dynamic created)
and i'm using ADO with C++

the table contains 8 fields, 3 int and 5 double
a primary key and two indexes.

i've been using batchupdate of ado, but it take nearly 70 seconds:(
is there any way to make it finish in 10 seconds?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

which way is the best to insert massive records into a table once? 2
MS Access Avoiding redundancy 1
How to export table from outlook into ms access table? 0
Cannot insert new record into sql 2005 View from Access form 1
Insert record into linked tables from Data Access Page 6
Losing Table Index 3
Data Access Page and Table of over 10000 records 2
Duplicate values in the index, primary key, or relationship messag 2

Back
Top