What's the fastest way to insert multiple rows into a table in SQL server 6.5? I cannot write the data to a text file and then bulk copy it in. Is there something I can do with an ADO recordset?
The fastest way I can think of is to call a separate INSERT statement for each row that needs to be inserted. It seems like there should be a faster way.