Updating CSV files with Connection object

[Nick]

Hi,

I have a scenario wherein I need to update a record in a CSV file. However,
it seems that with the connection string I am using,

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\Webroot\DB;Extended Properties='text;HDR=Yes;FMT=Delimited'"

I can merely insert and select, and not update. Anybody facing this problem?
And what is the alternative to it? I have been able to read from the CSV
files and have performed joins as well on multiple CSV files but am stuck on
the update functionality.
Any pointers on the approach?
I read somewhere that Jet.OleDB does not provide support for updates and
deletes... Is this true? and if yes, then what other connection can i use?

Nick.

[Paul Clement]

On Mon, 6 Jun 2005 03:08:01 -0700, "Nick" <Ni**@discussions.microsoft.com> wrote:

¤ Hi,
¤
¤ I have a scenario wherein I need to update a record in a CSV file. However,
¤ it seems that with the connection string I am using,
¤
¤ strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
¤ Source=D:\Webroot\DB;Extended Properties='text;HDR=Yes;FMT=Delimited'"
¤
¤ I can merely insert and select, and not update. Anybody facing this problem?
¤ And what is the alternative to it? I have been able to read from the CSV
¤ files and have performed joins as well on multiple CSV files but am stuck on
¤ the update functionality.
¤ Any pointers on the approach?
¤ I read somewhere that Jet.OleDB does not provide support for updates and
¤ deletes... Is this true? and if yes, then what other connection can i use?

The Text driver ISAM does not support updates and deletes so you can't really use ADO.NET. You will
need to use the System.IO namespace instead.
Paul
~~~~
Microsoft MVP (Visual Basic)