I often use Datasheet view in SharePoint to manipulate the data from the list. Few times I’ve met with the error “The List cannot be displayed in Datasheet view” when I tried to open the “excel” view.

This can be caused by an Office 2010 64-bit version installation on the local PC or even by the SharePoint Designer 2010 and happens only in Windows SharePoint Services 3.0(WSS) and Microsoft Office SharePoint Server 2007(MOSS).

The very simple solution for this is to install 2007 Office System Driver: Data Connectivity Components available here. After installation the Datasheet view should be working again.