Need Help converting a txtfile for sql use

September 5, 2010 at 07:39:46
Specs: Windows 7
Hi, Guys&Girls

I am new to the site and need help parsing a file the file has a max of 2000 line and looks like this


i need to convert the above so i can insert it directly in to an sql database it need to look like this exactly not sure what is the best way to do it either somekind of script to convert the file or a script sql script new to all this but getting there at the moment i have to do it manually which just takes me hours thanks in advance for your help

( , 1, '1006', '6473', '93-89-16', '94-21-33', '', 'Lee', 1283682460),

See More: Need Help converting a txtfile for sql use

Report •

September 5, 2010 at 08:57:58
Unless I'm missing something, it'd just be easier to tokenize each line, then feed it in as a set of parameters to a PreparedStatement. It's better database discipline, too.

Report •

September 5, 2010 at 09:07:48
Thanks for replying but i am very new to programing to getting to to know the basics i would be willing to pay for somebody to make the script/program for me


Report •

Related Solutions

Ask Question