Solved

Read Tab Delimited text into dataset

Posted on 2007-11-26
1
3,327 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
WPF - Tooltips for ComboBox items 5 33
update textboxes with Streamreader 21 42
Server Error 11 47
ASP.NET 5 Templates 2 65
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now