Connection string for text files

[TF]

hi,

Can anyone please tell me the ADO.NET connection string to access data
from flat files (CSV or other character delimited). I tried it with
OLE DB provider for ODBC (MSDASQL) but got error that it is not
supported in .NET.

Thanks in advance

TF

[Miha Markic]

Hi,

This one was suggested by Paul Clement a month ago or so:
Use the Jet OLEDB driver with the Text ISAM instead:

Dim TextConnectionString As String
TextConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "c:\TestData" & ";" & _
"Extended Properties=""Text;HDR=NO;"""
Dim TextConn As New
System.Data.OleDb.OleDbConnection(TextConnectionSt ring)
TextConn.Open()

Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from
test.csv", TextConn)

Dim ds As DataSet = New DataSet("CSVFiles")
da.Fill(ds, "test.csv")

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"TF" <fa****@coned.com> wrote in message
news:ae**************************@posting.google.c om...

hi,

Can anyone please tell me the ADO.NET connection string to access data
from flat files (CSV or other character delimited). I tried it with
OLE DB provider for ODBC (MSDASQL) but got error that it is not
supported in .NET.

Thanks in advance

TF

[TF]

Thanks Miha, it is working.

"Miha Markic" <miha at rthand com> wrote in message news:<eL**************@tk2msftngp13.phx.gbl>...

Hi,

Dim TextConnectionString As String
TextConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & "c:\TestData" & ";" & _
"Extended Properties=""Text;HDR=NO;"""
Dim TextConn As New
System.Data.OleDb.OleDbConnection(TextConnectionSt ring)
TextConn.Open()

Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from
test.csv", TextConn)

Dim ds As DataSet = New DataSet("CSVFiles")
da.Fill(ds, "test.csv")

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com