Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > Beginning VB 6
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Beginning VB 6 For coders who are new to Visual Basic, working in VB version 6 (not .NET).
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Beginning VB 6 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 27th, 2007, 06:32 AM
Authorized User
 
Join Date: May 2007
Location: Chennai, Tamilnadu, India.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to MathLearner
Default BULK INSERT FOR ARRAY

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

Reply With Quote
  #2 (permalink)  
Old September 27th, 2007, 10:46 AM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

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) & """"
Reply With Quote
  #3 (permalink)  
Old September 28th, 2007, 12:48 AM
Authorized User
 
Join Date: May 2007
Location: Chennai, Tamilnadu, India.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to MathLearner
Default

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..

Reply With Quote
  #4 (permalink)  
Old September 28th, 2007, 12:52 AM
Authorized User
 
Join Date: May 2007
Location: Chennai, Tamilnadu, India.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to MathLearner
Default

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..


Reply With Quote
  #5 (permalink)  
Old September 28th, 2007, 07:18 AM
Friend of Wrox
Points: 7,395, Level: 36
Points: 7,395, Level: 36 Points: 7,395, Level: 36 Points: 7,395, Level: 36
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Capital Federal, , Argentina.
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

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
================================================== =========
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk Insert snufse SQL Server 2000 9 December 17th, 2007 07:53 AM
bulk insert hymavathy_kr VB Databases Basics 1 May 17th, 2007 07:47 AM
BULK INSERT FAILS everest SQL Server 2000 0 February 23rd, 2006 12:55 PM
Bulk Insert luma SQL Server DTS 1 July 13th, 2005 01:48 AM
Bulk insert deyakhatib SQL Server 2000 6 March 4th, 2004 04:09 AM



All times are GMT -4. The time now is 11:22 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.