Update table with data from a csv

[SuperComputing]

OK I have a table with data like so:

COL1     |COL2|COL3| COL4 | COL5
------------------------------------
12340001 | 01 | 24 | XXXX | ________
12340002 | 08 | 03 | XXXX | ________
12340003 | 12 | 22 | XXXX | ________

And I have a csv like so:

1234001,ABCD
1234002,EFGH
1234001,IJKL

I need to (Bulk Insert?, maybe) the csv into the existing table. Read a line from the csv, compare the number in column 1 of the csv with the number in column 1 of the table, and when it finds a match, places the data in column 2 of the csv into the blank column 5 of the table. Next line...

Any suggestions or help GREATLY appreciated!!!

 

[SuperComputing]

OK just realized that while I was searching for the answer before I asked, I posted in the wrong forum, SORRY! I'll re-post in SQL.