Solved

Read Tab Delimited text into dataset

Posted on 2007-11-26
1
3,339 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB.Net - String Manipulation Scenario 2 31
Name Space error VS2015 1 37
TFS 2015 Access denied. 1 30
c#, case, if 4 22
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…

726 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