Have you found that you cannot update linked Excel tables in Access 2003+?
If you have installed Microsoft Office 2003 Service Pack 2 (SP2):
Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access.
You cannot change data in tables that are linked to an Excel workbook
You might try reinstalling and then only installing SP1.
Patent ruling costs Microsoft $8.9 million
"A jury in U.S. federal court found that Microsoft infringed on a Guatemalan inventor's 1994 patent on technology linking the company's Access and Excel programs, and ordered the world's largest software maker to pay $8.9 million in damages.
See all Topics