Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    We have attached to a named range in an Excel spreadsheet but the data is not updatable.

    Is it possible?

    I seem to recall that this may be a feature that MS had to remove after losing a pattent suit.

    Is this the case or is there another answer?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    I don't know the history of this, but this is what it says in Help:

    "When you link to an Excel worksheet or a named range, Access creates a new table that is linked to the source cells. Any changes you make to the source cells in Excel appear in the linked table. However, you cannot edit the contents of the corresponding table in Access. If you want to add, edit, or delete data, you must make the changes in the source file."
    Regards
    John



  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Further to my previous post I found this post which has this:
    [attachment=88246:warning.gif]
    Attached Images Attached Images
    Regards
    John



  4. #4
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    387
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks John, Yes this was the result of MS losing a pattent suit.

    We'll import the Excel data into a table then export it back to Excel once we've had our wicked way with it.

Posting Permissions

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