Posted by Andrew J. Kelly on 01/27/07 03:08

Your best bet is to import the addresses using DTS or SSIS and then doing an
update join.

--
Andrew J. Kelly SQL MVP

"Chris" <cjscully@gmail.com> wrote in message
news:1169857420.008804.271640@l53g2000cwa.googlegroups.com...
>I got got a pile of bad email addresses to update in our SQL database.
> I know how to do this for individual records using the update command.
> Is there a way to execute an update using the list of addresses in an
> excel spreadsheet or some other form of list? This kind of scripting
> is new territory for me.
>

[Back to original message]