Text data provider

[Guest]

In ODBC and ADO there was the capability to open delimited (tab etc.) text files. Is there the same capability with ADO.NET and can someone point me to some relevant documentation/examples?

 

[William Ryan eMVP]

Check out the Text provider http://www.connectionstrings.com

HTH,

Bill

--
W.G. Ryan MVP Windows - Embedded

www.devbuzz.com
www.knowdotnet.com
http://www.msmvps.com/williamryan/

In ODBC and ADO there was the capability to open delimited (tab etc.) text

files. Is there the same capability with ADO.NET and can someone point me to
some relevant documentation/examples?

 

[Val Mazur]

Hi,

Yes, this is the same in .NET, but I would suggest to use OLEDB JET provider
instead of text driver to read from the text files. Here is an example (in
VB6 but idea is the same and connection string will be the same in .NET)

http://support.microsoft.com/default.aspx?scid=kb;en-us;326548&Product=ado

 

[Paul Clement]

¤ In ODBC and ADO there was the capability to open delimited (tab etc.) text files. Is there the same capability with ADO.NET and can someone point me to some relevant documentation/examples?

Below is an ADO.NET example using the Jet OLEDB provider:

Dim ConnectionString As String
Dim SQLString As String

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\TextFiles;" & _
"Extended Properties=""Text;HDR=NO;"""

SQLString = "Select * from TextFile.csv"

Dim ConnectionText As New OleDb.OleDbConnection

ConnectionText.ConnectionString = ConnectionString

ConnectionText.Open()

Dim AdapterText As New OleDb.OleDbDataAdapter(SQLString, ConnectionText)

Dim DataSetText As New DataSet("TextFiles")
AdapterText.Fill(DataSetText, "TextFile")

DataGrid1.SetDataBinding(DataSetText, "TextFile")

ConnectionText.Close()


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)