How to write into Excel from Access 2007

[Catherine]

I used to update Excel spreadsheets from Access with update and append queries.
Now that I am with Office 2007 it seems that this feature is not allowed
anymore.
Is there an option to turn off or on?
Thanks in advance for your help.

 

[KARL DEWEY]

Open the query and then click on External Data and you will see Excel as an
option in the Export section.

 

[Roger Carlson]

If you're talking about updating Linked Excel tables, you haven't been able
to do that since Access 2000. Legal issues forced Microsoft to remove that
functionality. See this KB article: http://support.microsoft.com/kb/904953/


--
--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