I have just been configuring SP2010 for a client demo that I’m doing and uploaded a load of documents into a document library. I then wanted to easily set the metadata for all of the documents by working in Datasheet View but it wouldn’t allow me to.
It gave me the error message:
“A datasheet component compatible with Microsoft Sharepoint Foundation is not installed
Your web browser doesnt support Active X controls
A component is not properly configured for 32-bit or 64-bit support.”
The reason for this is that I am running the 64bit version of Office 2010 and it does not support this functionality. The solution I found is to install the 2007 Office System Driver: Data Connectivity Components.