Update a column in a table from a flat file

[John McKee <jmmckee@xxxxxxxxxxxxxx>]

My earlier question has been resolved.  Can't skip a key field in a database and
get decent performance.

Now, I wondering:

Run the Crystal report.  Export the rsssults to a flat file.  First field would
be a complete primary key to the MS-SQL database.  Third field would be the new
value for a single specified field.

One possibility would be to modify the text file to read like this:

update clinical set id= xxx where mrc=yyy

The above line would be modified so that a text file would have several thousand
individual update commands.  The file would be input to a command line program,
name eludes me for the moment.

Is there a way to do all the updates with a single command?

John McKee