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
