how to read txt file and then insert it to sql table

Question posted by: Gauravpimple (Newbie) on January 22nd, 2008 08:14 AM

HELLO,

please help me, how to read txt file and then insert it to sql table.

i have file like this listcon.txe

01A00 ELE SUPPLY 123A
01A01 INTEL INTFC CK1234AB HW12 FW012 01 02 03 04 05
01A02 INTEL TEST CK221SP HW23 FW056 u 02 03 04 05
---------------------
------------------------

I have 5 column and want to fractionise this text into 5 diffrent table.each data should be gone in its respective table

my problem is this data id not well divided some time space come or some time tab come between tow column, so how should i split the data.

plez help me.

Best regards

Gaurav.

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

RedSon

Site Moderator

2,855 Posts

January 22nd, 2008
09:08 PM
#2

Re: how to read txt file and then insert it to sql table

What language are you planning on using?

debasisdas

Moderator

6,450 Posts

January 23rd, 2008
06:32 AM
#3

Re: how to read txt file and then insert it to sql table

Instead of using text file try to use CSV file.

Not the answer you were looking for? Post your question . . .
183,969 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Top Software Development Forum Contributors