> Yes SQL server has a "bulk insert" facility. From a text > file. We had an app that was doing same as your doing, is was > a VB app tho not a webapp, but even this was cut down to a > 10th of the time using bulk insert. > > Just lookup "bulk insert" in your books online and should > tell you what u need.
Had a look again. This is only a bulk insert into one table though. I need to be able to bulk insert into many tables AND be able to keep relationships across those tables. I have written the stored procedure to do this, but it seems that it's just a little bit too weighty. Maybe insert into a "raw" temporary table and run the SP on that via a cursor? Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
