Skip to Main Content
Forums

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Inserting text file data into a database(sql server)

807588May 6 2009 — edited May 6 2009
Hai

I have a text file, test.txt in which the data is in the below format
Acno (1-10 positions)
CustId (11-18 positions)
AcType(19-25 positions)

Say

Acno CustId AcType
10000 2345 Savings
10001 1234 Current
10002 2367 Savings
:
:
:

I need to retreive the rows whose AcType is Savings from the above text file and insert into database as bulk.
I have 10000 records altogether, iam able to insert one row at a time satisfying all the conditions. But to improve the performance i need to insert a set of records at a time.
Pls help me out in doin this. Thanx in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2009
Added on May 6 2009
4 comments
1,023 views