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

 

[Paul Clement]

¤ 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 ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)