Linked Tables (Access 2000)

Topic

New Reply

I am working with a database that imports data from a text file, scrunches the data around, then should update several spreadsheets. These are basiclly template. One to be sent to a mailing list with just the data, the other creates several graphs.

The problem I am running into is, I have linked one of the sheets from the workbook. I then would like to delete the data in the sheet and replace it with an append query. When I try to run the delete query I get the following error.

“Deleting data in a linked table is not supported by this ISAM”

Any ideas. Will I run into the same issue with the append query?

Thanks for any help

Reply | Quote

Replies

You cannot delete records from linked XL files (although you can append records). You could use your append query as a select query and run a transfer command to transfer the query results to the XL sheet but keep in mind it will overwrite the entire workbook so you would want to separate your sheet from the rest of the workbook (you could always link back it to the workbook later).
Hope that helps.

Reply | Quote