Office 2010 64bit has no datasheet view
Problem
You try to access datasheet view in a SharePoint list and get the following error:
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.
Cause
Office 2010 64bit does not support data sheet view.
Resolution
Downnload the 2007 Office System Driver : Data Connectivity Components
http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734