[02/03] comma delimited txt file
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.
Re: [02/03] comma delimited txt file
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...