I used to update linked spreadsheets from a query in access with no problems in an earlier version of access (97). Now (access 2003) I don't seem to be able to.
Example-I link to tab "policies" in an excel file that contains policy counts by zip code. In an access database, I have a table zips with zipcodes and the county and state they are in. I want to add the county to the excel file. I set up a query with the linked excel tab and the access table and join them on the common zip field. Then try to do an update on [policies]![county] from [zips]![county] with [policies]![zip] joined to [zips]![zip]. Field types match etc. there's no obvious reason to me why this cant be done
I get a "cant update" error. When I go to the linked table and try to edit, I can't. The spreadsheet is not write protected or otherwise in use. Is there something that changed in the linking process between access 97 and access 2003? I can import and do the update and then export, but what a lot of extra work--can I update the spreadsheet directly somehow?
Tx
Dale
Example-I link to tab "policies" in an excel file that contains policy counts by zip code. In an access database, I have a table zips with zipcodes and the county and state they are in. I want to add the county to the excel file. I set up a query with the linked excel tab and the access table and join them on the common zip field. Then try to do an update on [policies]![county] from [zips]![county] with [policies]![zip] joined to [zips]![zip]. Field types match etc. there's no obvious reason to me why this cant be done
I get a "cant update" error. When I go to the linked table and try to edit, I can't. The spreadsheet is not write protected or otherwise in use. Is there something that changed in the linking process between access 97 and access 2003? I can import and do the update and then export, but what a lot of extra work--can I update the spreadsheet directly somehow?
Tx
Dale