This is a numbers game. Sometimes it can be hard to keep track of all the versions and editions you need to make your everyday work. You have Windows editions, Office editions, SharePoint editions etc. Whenever you play around with 64-bit editions of anything Microsoft-related software you have to be aware of your surroundings.

My setup:

• 64-bit windows 7
• 64-bit Office 2010
• 64-bit SharePoint designer 2010
• 64-bit SharePoint 2010

When I want to take a list in SharePoint and use Datasheet view I get an error, saying that I don’t have a datasheetcomponent installed.

To solve this download the 2007 Office system Driver: Data Connectivity Components.