Read Tab dilimeted file

[Guest]

Hi,
I have a excel file, also saved as tab delimited file. Now this tab
delimited file has text(as table) for eg

date empid empsal

10/01/2007 1 20000

now i want to read this table from txt file into a dataset.
How can I do that.

Thanks

 

[Peter Duniho]

Hi,
I have a excel file, also saved as tab delimited file. Now this tab
delimited file has text(as table) for eg

date empid empsal

10/01/2007 1 20000

now i want to read this table from txt file into a dataset.
How can I do that.

You'll want to look at methods such as StreamReader.ReadLine(),
String.Split(), and the Parse() method (and related) on the various
types you'll want to generate (such as DateTime and Int32).

Pete

 

[Andrew Faust]

An alternate method would be to use the Microsoft Text Driver with the
OdbcConnection & OdbcDataAdapter to open the file as though it were a
database and simply fill the data set directly.

 

[Nicholas Paldino [.NET/C# MVP]]

Or, one could use the Jet provider and the OleDb data providers:

http://msdn2.microsoft.com/en-us/library/ms974559.aspx


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

An alternate method would be to use the Microsoft Text Driver with the
OdbcConnection & OdbcDataAdapter to open the file as though it were a
database and simply fill the data set directly.

--
Andrew Faust
andrew[at]andrewfaust.com
http://www.andrewfaust.com

You'll want to look at methods such as StreamReader.ReadLine(),
String.Split(), and the Parse() method (and related) on the various types
you'll want to generate (such as DateTime and Int32).

Pete

 

[Marc Gravell]

The following can be used to read csv/tsv in managed code (by changing
the delimiter); I have used it a number of times without issue.

http://www.codeproject.com/cs/database/CsvReader.asp

Marc