Links to Excel File not working

S

suejay

I have been using the 'Get External Data' feature in Access 2003 for quite
some time to link to an Excel spreadsheet, and the link has always updated
fine. I had a new install of Access 2003 on my PC done and now my links
won't update. Is there an plug-in that could be missing?
 
J

John W. Vinson

I have been using the 'Get External Data' feature in Access 2003 for quite
some time to link to an Excel spreadsheet, and the link has always updated
fine. I had a new install of Access 2003 on my PC done and now my links
won't update. Is there an plug-in that could be missing?
Click to expand...

No; Microsoft lost a lawsuit last year and was required to (or chose to)
remove the capability for Access to update linked Excel spreadsheets. The
change was made in a (required) service pack, and implemented in any version
of Access you can now buy.
 

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 Excel File won't update 1
Linked Excel spreadsheet to be used as table 3
link data - from excel into access 1
linking to an Excel spreadsheet 1
unable to work in an excel file and an access file at the same tim 2
Update Query from Access 2003 Linked Table 1
Changing Links to access databases 1
Can you use Access as an interface to Excel? 5

Top