Fix for : The List cannot be displayed in Datasheet view (WSS 3.0 and MOSS 2007).

The List cannot be displayed in Datasheet view (WSS 3.0 and MOSS 2007).

Issue:
I also had the same problems on a Windows 7 64 bit Ultimate machine, running Office 2010 64 bit. I installed the 2007 Office System Driver: Data Connectivity Components as instructed on the local machine and did indeed fixed the Datasheet funcitionality.

Solution:
http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
2007 Office System Driver: Data Connectivity Components