oledb and csv updateable?

[Fred Flintstone]

I have connected to some csv files using oledb, and am able to acces the
data vis SQL statements.
Is it possible to update the tables, via insert statements?
I have not been able, but can't remember the error, I'm not at my developer
PC.
Something about key fields.
Regardless of my problem, does anyone know if it can be done, and if so have
a snipet to demonstrate?

any assistance will be appreciated.

[Bernie Yaeger]

Hi,

It's data so it should be updateable. The error you are getting probably
relates to the fact that the csv file has no primary key field(s) and you
are probably not creating an update command manually. The commandbuilder
object is very generic and wants to be able to update only single tables
which do have primary keys.

HTH,

Bernie Yaeger

"Fred Flintstone" <de**********@rogers.com> wrote in message
news:bO********************@rogers.com...

I have connected to some csv files using oledb, and am able to acces the
data vis SQL statements.
Is it possible to update the tables, via insert statements?
I have not been able, but can't remember the error, I'm not at my
developer PC.
Something about key fields.
Regardless of my problem, does anyone know if it can be done, and if so
have a snipet to demonstrate?

any assistance will be appreciated.

[Paul Clement]

On Tue, 26 Oct 2004 19:01:03 -0400, "Fred Flintstone" <de**********@rogers.com> wrote:

¤ I have connected to some csv files using oledb, and am able to acces the
¤ data vis SQL statements.
¤ Is it possible to update the tables, via insert statements?
¤ I have not been able, but can't remember the error, I'm not at my developer
¤ PC.
¤ Something about key fields.
¤ Regardless of my problem, does anyone know if it can be done, and if so have
¤ a snipet to demonstrate?
¤
¤ any assistance will be appreciated.
¤

The Text ISAM driver does not support the ability to update a text file. You would need to use the
file I/O classes to perform the updates.
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)