import

[Viswanathan S]

Hi All!

How to import text file into vb.net dataset?

For example a text file with 1000 records as tab delimited text. The text
file contain string, number and date field data. I want to extract the data
between two dates from the text file and bind to the dataset.

How can i do this?

TIA
______________________________

S. Viswanathan

 

[Cor Ligthert [MVP]]

Viswantan,

The most simple way

http://www.windowsformsdatagridhelp.com/default.aspx?ID=1b644f6b-aa01-49f6-bc1f-212f9e0de193

I hope this helps,

Cor

 

[Herfried K. Wagner [MVP]]

How to import text file into vb.net dataset?

For example a text file with 1000 records as tab delimited text.

<URL:http://www.connectionstrings.com/>
-> "Text"

 

[Paul Clement]

¤ Hi All!
¤
¤ How to import text file into vb.net dataset?
¤
¤ For example a text file with 1000 records as tab delimited text. The text
¤ file contain string, number and date field data. I want to extract the data
¤ between two dates from the text file and bind to the dataset.
¤
¤ How can i do this?

Tab delimited text files require a schema.ini file. It would look something like the following and
is located in the same folder as the text file(s).

[TabDelimitedFile.txt]
ColNameHeader=False
Format=TabDelimited
CharacterSet=ANSI

Code:

Dim ConnectionString As String
ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "E:\My Documents\TextFiles" & ";" & _
"Extended Properties=""Text;HDR=No;"""

Dim TextConnection As New System.Data.OleDb.OleDbConnection(ConnectionString)
TextConnection.Open()

Dim da As New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM TabDelimitedFile.txt",
TextConnection)

Dim ds As New DataSet("TextFiles")
da.Fill(ds, "TabDelimited")


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Viswanathan S]

Thanks for all to send the sample codes.

S. Viswanathan