Read Tab Delimited text into dataset

I have a tab delimited text file that I need to read into a dataset.  I have tried using Microsoft Jet OLEDB4.0 approach, which I can't seem to get to work and I also tried using a TextFieldParser, which almost worked, I was able to read a single row in.   An example of reading in tab delimited text into a dataset (datatable, whatever) using VB.net 2.0 would be greatly appreciated.  I have found a ton of examples on the web, however (at least so far) none of them have worked.

thanks,
LVL 1
clintnashAsked:
Who is Participating?
 
gnoonConnect With a Mentor Commented:
1. Create a folder to contains data files e.g. c:\data
2. Copy the tab delimited file(s) into the folder e.g. data.tab
    The file must contains only data, and no column names at the first line.
3. Create a file named schema.ini in the folder, and contains this information
      [data.tab]
      Format=TabDelimited
4. Write a program to read the file data.tab
Dim myConnection As New System.Data.OleDb.OleDbConnection( _
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data;" & _
    "Extended Properties='text;FMT=TabDelimited;HDR=YES;'")
Dim myCommand As New System.Data.OleDb.OleDbCommand( _
    "SELECT * FROM data.tab", myConnection)
Dim sd As DataSet = New DataSet
Try
    myConnection.Open()
    Dim query As System.Data.OleDb.OleDbDataAdapter = _
	New System.Data.OleDb.OleDbDataAdapter(myCommand)
    query.Fill(sd)
    For Each r As DataRow In sd.Tables(0).Rows
	For Each o As Object In r.ItemArray
	    Console.Write(o & " ")
	Next
	Console.WriteLine()
    Next
Finally
    myConnection.Close()
End Try

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.