Update Link Tables from Excel

[BlairH]

I recently got an update from Office 97 to Office 2003. We're just slightly
behind the times.

Anyway, I had an access database in 97 that would link to an Excel file that
I would use to add data to the Excel file based upon information in a master
table in Access.

Now when I try to run the query in Access 2003, it gives me an error that it
is not an updateable query.

I suppose I could export the master data to an Excel spreadsheet and use a
VLookup function, copy and paste to all the records that need to be updated
and the copy and paste values, but I originally did this in Access to make it
simpler.

Any ideas why it no longer works?

Thanks!

 

[BlairH]

Nevermind - foundthis statement on article 904953:

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.

Probably should have stayed with 97.