Solved

Read Tab Delimited text into dataset

Posted on 2007-11-26
1
3,330 Views
Last Modified: 2013-11-07
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,
0
Comment
Question by:clintnash
1 Comment
 
LVL 16

Accepted Solution

by:
gnoon earned 500 total points
ID: 20356411
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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question