Bulk Insert/Update Suggestions....

Hello All,

I'm working on developing a web based application that will allow the bulk updating of a SQL Server 2000 database. The updates will vary in size from 8 records to upwards of 8000 records, and they will be in Excel file format. I am wondering if anyone has any suggestions or links that they could provide to help me develop a Stored Procedure on the SQL Server to allow for this to happen. I have been trying Google, but perhaps I'm just not typing the correct search string!!! :) :) :)

Anyway, if anyone could provide thoughts/suggestions, I'm all ears!

Thanks,

Jim P.

Use DTS. You can get a lot of info on dts on http://www.sqldts.com

yup... bulk insert.. SQL Server has

but not bulk export.. but in sqldts they have a downloadable module for it. I think. :D

Or how about mutliple INSERT statements.. Not pretty, but it works.