May 6, 2004 #1 gdrenfrew Programmer Aug 1, 2002 227 0 0 GB Hi there, I'm using VB6 and ADO to connect to my database (SQL Server 2000). I am wondering if it's more efficient to use SQLXMLBulkLoad to insert 40 rows into a table than do 40 individual row inserts from data in a recordset? Thanks
Hi there, I'm using VB6 and ADO to connect to my database (SQL Server 2000). I am wondering if it's more efficient to use SQLXMLBulkLoad to insert 40 rows into a table than do 40 individual row inserts from data in a recordset? Thanks