Linking Access 2003 table to Excel 2003 spreadsheet

[hp]

Hello there,

I am trying to establish a link between an Access 2003 table and an Excel
2003 spreadsheet. I have already tried to use the get external data feature
but it only allows me to link the Excel spreadsheet to an Access table; not
the other way around. I am in a network environment and the database is
password protected. I would like the excel spreadsheet to update when the
Access table gets updated.

Thanks for the help

 

[Jerry Whittle]

A couple of years ago, you could do this. However due to a Patent dispute,
you cannot change, add, or delete data in tables that are linked to an Excel
workbook in Office Access 2003 or in Access 2002!

http://support.microsoft.com/kb/904953

http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/