Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Linked Excel sheet wont allow me to update via tbl (Access@003 SP2)

    I have linked a spreadsheet to access and cannot change data in datasheet view of the table.

    I need to update the sheet via VBA. I have gone for the linked table approach rather than Excel Austomatio. is either way better than the other?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linked Excel sheet wont allow me to update via tbl (Access@003 SP2)

    Lined Excel tables cannot be updated. This used to be possible in the past, but Microsoft lost a lawsuit over the use of the technology behind it, and disabled the feature sometime in 2005. See You cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2007, Office Access 2003, or Access 2002.

    You can use Automation to update the workbook.

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Linked Excel sheet wont allow me to update via tbl (Access@003 SP2)

    I figured it was not allowable in later versions as i am sure it used to work in Access 2000.

    Thanks Hans.

Posting Permissions

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