Datasheet view Error for SharePoint with Office 64-bit versions

When you upgrade your Office versions to newer versions (mostly 64-bit), you would have come across the below error trying to access datasheet view in SharePoint:

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.

Solution:

Follow the below kb article from Microsoft:

http://support.microsoft.com/kb/2266203

• Install the 2007 Office System Driver: Data Connectivity Components                   http://www.microsoft.com/en-us/download/details.aspx?id=23734