Click here to Skip to main content
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 4:12am
Edited 22-Apr-11 7:07am
thatraja242.7K
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 OriginalGriff 215
1 George Jonsson 175
2 Kornfeld Eliyahu Peter 159
3 PIEBALDconsult 110
4 Richard MacCutchan 85
0 OriginalGriff 6,080
1 DamithSL 4,648
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,624
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 25 Apr 2011
Copyright © CodeProject, 1999-2014
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