Editing linked tables

[AH]

Hello,

I have linked a CSV file to my Access 2002 database. When
I try to change any cell in any record in Access I get
this error:

"Updating data in a linked table is not supported by this
ISAM."

I remember a while back I could edit linked tables in
Access. What did I forget? Thanks for the help.

 

[John Nurick]

I don't think it's ever been possible to edit linked CSV files. The
problem is that any edit that changes the length of the data in any
field requires the whole of the rest of the file to be rewritten, and
this is impractical except with small files.

So for manual editing it's simplest to import the data to an Access
table, edit it, and export again. For editing under program control,
either link the file and use a make-table query to create the edited
file, or else write VBA code to read the file line by line, editing and
outputting the lines to a new file.

Hello,

I have linked a CSV file to my Access 2002 database. When
I try to change any cell in any record in Access I get
this error:

"Updating data in a linked table is not supported by this
ISAM."

I remember a while back I could edit linked tables in
Access. What did I forget? Thanks for the help.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

 

[AH]

Thanks John, I guess importing the file is the simplest
solution around this problem.

-----Original Message-----
I don't think it's ever been possible to edit linked CSV files. The
problem is that any edit that changes the length of the data in any
field requires the whole of the rest of the file to be rewritten, and
this is impractical except with small files.

So for manual editing it's simplest to import the data to an Access
table, edit it, and export again. For editing under program control,
either link the file and use a make-table query to create the edited
file, or else write VBA code to read the file line by line, editing and
outputting the lines to a new file.

Hello,

I have linked a CSV file to my Access 2002 database. When
I try to change any cell in any record in Access I get
this error:

"Updating data in a linked table is not supported by this
ISAM."

I remember a while back I could edit linked tables in
Access. What did I forget? Thanks for the help.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.