Why do you have to do it that way? Could you do it in a loop?
Do Until rst.EOF dbConn.Execute("INSERT STATMENT"); Loop JFernando ** sql ** -----Original Message----- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 13:55 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk Inserts Hi, That is how I currently submit my statements, but can't I go: Hi, that is how I execute my current statements. But can't I submit multiple statements like: "INSERT INTO tblname(fld1) VALUES(val1);INSERT INTO tblname(fld1) VALUES(val1);"? If I submit multiple statements I get a SQL error. At 12:55 PM 12/10/2002 -0500, Fernando Grijalba wrote: >Have you try this: > >dbConn.Execute("INSERT INTO tblname(fld1, fld2) VALUES(val1, >val2),(val1,val2),(val1,vla2);") > >JFernando >** sql ** > >-----Original Message----- >From: Michael She [mailto:[EMAIL PROTECTED]] >Sent: December 10, 2002 12:08 >To: Fernando Grijalba >Cc: MySQL Help >Subject: RE: ADO Bulk Inserts > > >Same table, but it shouldn't matter right? > >I'm getting a SQL syntax error once I start combining my statements >together. If I submit the statements separately they're OK. > > > >At 09:59 AM 12/10/2002 -0500, Fernando Grijalba wrote: > >Are the inserts to the same table or different tables and columns? > > > >JFernando > >** sql ** > > > >-----Original Message----- > >From: Michael She [mailto:[EMAIL PROTECTED]] > >Sent: December 9, 2002 14:56 > >To: MySQL List > >Subject: ADO Bulk Inserts > > > > > >Hi All, > > > > > >Does MySQL allow for Bulk Inserts via ADO? > > > >I can get a single insert statement to be inserted, but if I try t > >concatenate multiple inserts, I get a sytax error. > > > >I tried putting a space between each statement, return charater, > >semi-colon, etc, but it doesn't work. > > > >I'm doing the inserts through a ADODB.Connection. > > > >Thanks. > >-- > >Michael She : [EMAIL PROTECTED] > >Mobile : (519) 589-7309 > >WWW Homepage : http://www.binaryio.com/ > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > ><[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >-- >Michael She : [EMAIL PROTECTED] >Mobile : (519) 589-7309 >WWW Homepage : http://www.binaryio.com/ > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php