[02/03] comma delimited txt file

[GUARO]

Hi gurus.

Need help

I need to read a comma delimited txt file and while I read line by line I would like to transfer the info to a sql table.

the file format is as follow

03/01/2007," 599549","06530999","AJ FREAS",61143,03/14/2007,1.19
03/01/2007," 599552","06530345","TONNY LUMAR",61139,03/14/2007,4.79
03/01/2007," 599554","07530123","MIRIAN GONZAL",1137,03/14/2007,302.40

Thanks a bunch gurus for any help I can get.

[stanav]

You need to parse the cvs file into a datatable, then use ado.net to update that table to your database. There are sample codes to do this thruout the forum, just do a simple search and you should find something useable...