The list cannot be displayed in Datasheet view for one or more of the following reasons:
- A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
- Your Web browser does not support ActiveX controls.
- A component is not properly configured for 32-bit or 64-bit support.
This error indicated a component that required to display the Datasheet View is missing. Since I did not install any Microsoft Office Clients on the server such as Microsoft Word or Microsoft Excel, I will need to install the 32-bit version of Microsoft Office System Driver: 2007 Office System Driver: Data Connectivity Components to enable the Datasheet component.
After the component installed, the list could be displayed as a datasheet now. This solution will work with the 64-bit version of Office 2010 as long as I am using a 32-bit version of an Internet browser.
Note: If you are using a 64-bit version of an Internet browser, for example the 64-bit version of Microsoft Internet Explorer 8.0, there is no support for the Edit in Datasheet feature.
More information about this issue could be found: