reading a pipe delimited text file

[CRP]

I need to read a text file which is delimited with pipe symbol and then save the contents of the text file in sql server using vb.net. How to achieve it. I need the full coding. Pls help. I am new to vb.net

 

[giadich]

Welcome to the forum!

We'd be glad to help you and provide assistance to help you complete your project. However, if you are looking for someone else to code your project for you, I doubt this forum is the place.

 

[JohnH]

CRP can get the Studio to write most of the code to parse the file Use the Insert Snippet feature and choose category 'Processing files' and select the 'Read a Delimited Text File' snippet, then change the default separator from comma to pipe character. The code give you a String array for each line read.

 

[cjard]

and then read the DW2 link in my signature for how to read and write a database.. Start with Creating a Simple Data Ap p