Update Link Tables from Excel

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!

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.

"BlairH" wrote:

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!