Click here to Skip to main content
11,578,739 members (60,022 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Oracle VB.NET
I have one flat file which has information delimited by pipe. I need to read the file and insert data to Oracle.

Can someone please help me?

Thanks.
Posted 22-Apr-11 3:12am
Edited 22-Apr-11 6:07am
thatraja246K
v2
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

String.Split would be your simplest option.

The VB assembly also includes the TextFieldParser class:
http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.fileio.textfieldparser.aspx[^]
  Permalink  
v2
Comments
SAKryukov at 22-Apr-11 22:43pm
   
Reasonable, a 5.
--SA
Nishant Sivakumar at 23-Apr-11 9:18am
   
Thank you, SA.
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

I am new to vb.net.

I would really appreciate if you or someone can help me with sample code. Also, I was looking for inserting data in Oracle database.

Thanks in advance.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Peter Leow 135
1 Frankie-C 115
2 OriginalGriff 113
3 Richard MacCutchan 85
4 Afzaal Ahmad Zeeshan 75
0 OriginalGriff 933
1 Sergey Alexandrovich Kryukov 740
2 Abhinav S 573
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 403


Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 25 Apr 2011
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100