Article Content
The papers that Microsoft at present (June 2004) have comparing what you get with Office 2000; Office XP and Office 2003 say that "Edit in Datasheet View" is a function of Office 2003.
It is but only if you are running Office 2003 Professional.
It is not included in either Office 2003 Standard or Office 2003 Small Business Edition.
Finally, a source that prefers to remain anonymous told me that it is possible to get Edit in Datasheet to work with Office 2003 Business Edition (*note that Monty extends this to Standard Edition*) by making a registry change. Here's his (or her!) text.
"It seems that if you set:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion]"ProInfo"=dword:00000001
on a machine with Office SBE or Standard you don't even need to exit IE. The next time you click on "Edit in Datasheet", off you go."
Alex Angas points out that the KB article http://support.microsoft.com/kb/909506
Subscribe to:
Post Comments (Atom)
2 comments:
I have Microsoft Office 2003 Standard Edition and the "File Format Converters" for Office 2007 documents installed, but does not work. How can I change?
Thanks
That trick won't work "as is" since you need stslist.dll related stuff for the Data View to work. Office 2003 Standard lacks those components.
You may however obtain them by installing the free Access Runtime or Databae Engine. And if you choose 2007 or 2010, you won't even need the registry hack.
Actually, after you install only this small thing:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D
you don't even need the Office suite.
Post a Comment