Mark,

The test I am doing is on a dedicated LAN (NT Server linked directly to Win95) with just the two PCs on BNC about two feet away from each other. The tables on SQL Server are presently empty. The structure is about 100 bytes, the clustered (Primary) index is the Identity column incremented by one. I have only got to about 300 rows so far before I aborted. Bulk inserting into a temporary table wouldn't work in this case because the tables I am working on at the moment are empty anyway.

>
>Hi,
>
>1 second per row seems slow, is your network link to your server over a WAN and not a local link? If so then whatever you do, you are limited by the speed of your network.
>
>I have used SPT
>
>=SQLEXEC( lnHandle, "INSERT INTO table .........")
>
>to insert one record at a time in a loop, and I am sure that I was acheiving at least 100 / sec. I haven't got the exact figures to hand. This would be over a LAN connection though.
>
>Maybe the speed issue is because of the size / indexes of your SQL Server table, in which case you might bulk insert the records into a temporary table on the server, then run a stored procedure to update the main table.