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