Updating a table using excel as a source

[redbunny78]

Using SQL 2000

I need to update a pricing table based on data I have in an excel spreadsheet.

I need to update the table partprice based on the partnum.

The excel spreadsheet has two columns that contain the partnum and the updated price.

What is the best method to do this? A DTS package? Any advice would be great!

Thanks!

 

[philhege]

DTS is usually the way to go. Just be VERY careful of the integrity of the submitted data. Think about putting some pre-upload checks in your package before doing the actual update, so you don't have a day like I've had so far today.



Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
A virtual machine ate my accounting data. I transferred it to a physical box, then I beat it to smithereens with a sledgehammer. I feel better.

 

[redbunny78]

I'm a bit confused about which transformation this would be. I don't see update as an option.

Sorry for being so generic, this is the first time I've used it.

Thanks

 

[AlexCuse]

You'll need to import your excel sheet to some kind of staging area, then do your update by joining to this table in a normal update query (which can be executed from the SQL Task in DTS).

Hope this helps,

Alex

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page