Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Tables (Access 2000)

    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
    Richard

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linked Tables (Access 2000)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •