Can't update Fields in a Linked Excel sheet from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AccessHar - 30 Jul 2007 14:44 GMT

with Access 2007, I noticed that the facility to link to an excel sheet
specifically mentions that "source data can not be changed from within
Access".

I was able to carry out SQL updates in Access 2000, how can this
functionality be found in access 2007

Reply to this Message

Roger Carlson - 30 Jul 2007 14:50 GMT

You can't do this any longer. The change happened back in Office XP (2002)
and it happened for legal reasons. See this link for more information and
workaround.
http://support.microsoft.com/kb/904953

Signature

--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

> with Access 2007, I noticed that the facility to link to an excel sheet
> specifically mentions that "source data can not be changed from within
> Access".
>
> I was able to carry out SQL updates in Access 2000, how can this
> functionality be found in access 2007

Reply to this Message