Reading text file using ADO.net

[Simon Verona]

Not sure if this is the best group... it may be better off in one of the ADO
groups, but I'm sure somebody here knows the answer:

I'm trying to load up a text file using ADO.net, as follows:

Dim TextConnectionS tring As String

TextConnectionS tring = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _

"Data Source=" & FilePath & ";" & _

"Extended Properties=""Te xt;HDR=NO;FORMA T=Delimited"""

Dim TextConn As New System.Data.Ole Db.OleDbConnect ion(TextConnect ionString)

TextConn.Open()

Dim da As New System.Data.Ole Db.OleDbDataAda pter("Select * from " &
filename, TextConn)

Dim ds As DataSet = New DataSet("CSVFil es")

da.Fill(ds, filename)

When I run this, it fails at the "fill" statement with the error "Database
or object is read only".

The file in question can definitely be read and written (it's a short CSV
file). What have I done wrong???

Many thanks in advance.

Simon

[Cor]

Hi Simon,

I am also not sure if this is the wrong group, but I am sure that you are
missing a command.

Dim cmd As New OleDbCommand(sq lStr, Conn)
Dim da As New OleDbDataAdapte r(cmd)

Not saying that I know of the rest works.

But maybe it was only this?

Cor

[Herfried K. Wagner [MVP]]

* "Simon Verona" <ne**@aphrodite uk.com> scripsit:

Not sure if this is the best group... it may be better off in one of the ADO
groups, but I'm sure somebody here knows the answer:

I'm trying to load up a text file using ADO.net, as follows:

Dim TextConnectionS tring As String

TextConnectionS tring = "Provider=Micro soft.Jet.OLEDB. 4.0;" & _

Typical question for this group:

<news://msnews.microsof t.com/microsoft.publi c.dotnet.framew ork.adonet>

Web interface:

<http://msdn.microsoft. com/newsgroups/default.asp?url =/newsgroups/loadframes.asp? icp=msdn&slcid= us&newsgroup=mi crosoft.public. dotnet.framewor k.adonet>

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>