Click here to Skip to main content
11,644,286 members (68,046 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
thatraja246.2K
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 650
1 jyo.net 494
2 Afzaal Ahmad Zeeshan 423
3 Sergey Alexandrovich Kryukov 409
4 CPallini 352
0 OriginalGriff 925
1 DamithSL 636
2 Afzaal Ahmad Zeeshan 622
3 Sergey Alexandrovich Kryukov 548
4 CPallini 521


Advertise | Privacy | Mobile
Web04 | 2.8.150731.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