The Datasheet view of this list cannot be displayed.

When you get the below error while viewing a list view data :

The Datasheet view of this list cannot be displayed. Please wait while the page is redirected to Standard view. If your list does not appear in a few moments, open the list in Standard view.

Install the 2007 Office System Driver: Data Connectivity Components from the link.