B
Boo Ray
Anybody have a way to update Excel spreadsheets through a link like we did
before Microsoft took away the function?
before Microsoft took away the function?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom van Stiphout
On Tue, 27 Nov 2007 05:44:06 -0800, Boo Ray
From the A2007 help file:
Any changes you make to the source cells in Excel appear in the linked
table. However, you cannot edit the contents of the corresponding
table in Access. If you want to add, edit, or delete data, you must
make the changes in the source file.
-Tom.
From the A2007 help file:
Any changes you make to the source cells in Excel appear in the linked
table. However, you cannot edit the contents of the corresponding
table in Access. If you want to add, edit, or delete data, you must
make the changes in the source file.
-Tom.
B
Boo Ray
Tom van Stiphout said:On Tue, 27 Nov 2007 05:44:06 -0800, Boo Ray
From the A2007 help file:
Any changes you make to the source cells in Excel appear in the linked
table. However, you cannot edit the contents of the corresponding
table in Access. If you want to add, edit, or delete data, you must
make the changes in the source file.
-Tom.
B
Boo Ray
Tom van Stiphout said:On Tue, 27 Nov 2007 05:44:06 -0800, Boo Ray
From the A2007 help file:
Any changes you make to the source cells in Excel appear in the linked
table. However, you cannot edit the contents of the corresponding
table in Access. If you want to add, edit, or delete data, you must
make the changes in the source file.
-Tom.
Tom,
I understand what you are saying but, prior to this change you could link an
Excel sheet into Access. Run an update query and update data within the Excel
sheet. Now when you attempt to do this you get the error message: Cannot
update <field name>; field not updatable. (Error 3113).
Importing rather than linking is not always practical or possible. I hate
to return to the world of vertical lookups!
Bob
D
Douglas J. Steele
The ability to update a linked Excel sheet was removed from Access 2002 and
2003 almost two years ago, due to Microsoft losing a lawsuit
http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/
Jamie Collins showed a work-around for Access 2003 in
http://groups.google.com/group/microsoft.public.access/msg/c50fa65815f3fe38
Not sure whether you can use the same in Access 2007.
2003 almost two years ago, due to Microsoft losing a lawsuit
http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/
Jamie Collins showed a work-around for Access 2003 in
http://groups.google.com/group/microsoft.public.access/msg/c50fa65815f3fe38
Not sure whether you can use the same in Access 2007.
B
Boo Ray
That's pretty sad. So I guess there is no solution from Microsoft.
I can't review the google link from here because of our firewall, I'll check
it at home. Does the Guatemalan inventor, Carlos Amado, offer any aftermarket
software I can buy to perform this Access to Excel magic? Or his he just
sitting back enjoying the nine million bucks Gates sent to him? I never did
get my check after forwarding all those emails back in 97! lol
I can't review the google link from here because of our firewall, I'll check
it at home. Does the Guatemalan inventor, Carlos Amado, offer any aftermarket
software I can buy to perform this Access to Excel magic? Or his he just
sitting back enjoying the nine million bucks Gates sent to him? I never did
get my check after forwarding all those emails back in 97! lol