Updating columns in sql server from text files

[amas]

I created a new database called employee180906. I need to update one column in the database with entries from a text file with contents as shown below:

PEN100066497926 ,PR0000003584
PEN100066498031 ,PR0000003584
PEN100066498117 ,PR0000003584
PEN100066792318 ,PR0000003584

each detail in a row in the text file is seperated with a comma. for instance, what i really need to do is where the script sees PEN100066497926 , it should update col 005 with PR0000003584.

Pls can someone help me fast? Lots of thanks.

[Senthil]

Hi,

To copy text file into database ,

use the DTS method

Regards,
Sharmila

I created a new database called employee180906. I need to update one column in the database with entries from a text file with contents as shown below:

PEN100066497926 ,PR0000003584
PEN100066498031 ,PR0000003584
PEN100066498117 ,PR0000003584
PEN100066792318 ,PR0000003584

each detail in a row in the text file is seperated with a comma. for instance, what i really need to do is where the script sees PEN100066497926 , it should update col 005 with PR0000003584.

Pls can someone help me fast? Lots of thanks.