MS SQL Bulk Update

[javiervasquez_94]

Hi,

I've got a product table with about 16000 items. I now need to update about 300 of the quantities. The update information is in a simple Excel sheet consisting of 2 columns (product_name, qty).

Rather than doing 300 plus individual updates, how best would I perform a bulk update?

Thanks

[wwb_99]

Easiest way--use Access. Import excel table, link to SQL table, do update query. At least if it is a one off type of thing.

Other method would be to setup a DTS package which is a bit more involved.

WWB

[zakruvalcaba]

BCP Utility would work too:

http://msdn.microsoft.com/library/de...p_bcp_61et.asp

[javiervasquez_94]

Easiest way--use Access. Import excel table, link to SQL table, do update query. At least if it is a one off type of thing.

Other method would be to setup a DTS package which is a bit more involved.

WWB

Hi,

Thanks for the response... I guess my question then is:

How do I build the Update query??

I've got no problem using the DTS functionality, I just don't see how I go about getting the destination table to update only those rows which are contained in the source...

Thanks

[Thing]

Just import the excel spreadsheet into a temp table, and do an update off of an INNER JOIN on your products table.

Make sure you do a standard select statement first to make sure your query is perfect before you update your products table. The last thing you want to do is mess up 16000 records.