Linked Excel Tables No Longer Updatable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003. I have a database that contains several linked Excel
tables. Prior to Office Service Pack 2, I was able to update those tables.
But ever since Office SP2 was installed, those linked tables are no longer
updatable, and are now read-only. I suspect Microsoft made a change
somewhere in the Jet engine (but jeez, why in a service pack???!!!). I have
an important VBA routine that depends on those linked tables being writable.
Does anyone have info on this, or can suggest something I need to do to make
them updatable under SP2? I've been wanting to go back to Office SP1, but
can't find an uninstall option. Anyone know how to do THAT? Thanks.
 
Microsoft lost a lawsuit, and was forced to remove the ability to update
linked Excel tables.

You'll have to try a different approach, such as Automation, or using
TransferSpreadsheet to export the data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Changed relationship; records no longer linked 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
linked tables no longer listed 1
linking tables and relationships 3
create one table using multiple linked tables 6
Break the linked tables 6
linked tables 2007 <--> 95 4

Back
Top