HI :)
  HOW TO BULK INSERT AN ARRAY DATA TO MS-ACESS DB/SQL..
 PLS HELP US

There is no "bulk insert" functionality.

To insert these data you should open a recordset, use the .AddNew method, fill in the fields’ values and .Update the recordset.

An alternate way is to sumbit SQL against the DB for each element something like:

INSERT INTO <tableName> (Fld1, Fld2, Fldn
VALUES ( """ & Array(n)(0) & """, """ & Array(n)(1) & """, """ & Array(n)(n) & """"

hi sir
      T
     Actually iam using that query only. but it is time consuming.the main pblm here it is inserting the data one by one.
so only we need bulk insert functionality to insert array data..
     pls refer to this link.
       In this link they have created stored procedure and they uses occi in c++.
in there pgm they have used bulk insert.they have updated only once.
like that is there any possiblity for us..
help us..

hi sir
      Thank u for ur kind response.
     Actually iam using that query only. but it is time consuming.the main pblm here it is inserting the data one by one.
so only we need bulk insert functionality to insert array data..
     pls refer to this link.
---------------------------------------------------------------------------------
http://www.dbforums.com/archive/inde...t-1606717.html
---------------------------------------------------------------------------------
       In this link they have created stored procedure and they uses occi in c++.
in there pgm they have used bulk insert.they have updated only once.
like that is there any possiblity for us..
help us..

hi there...

but you are working with access, that doesn't have Store Procedures.. so your only way to do this is passing the rows one by one..

maybe you are not using the right database for this?? How much data are you inserting?? did you know that access database has a cap at 2 GB? (1 GB is you are using access 95)...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========