Using Datasheet view in SharePoint, when using 64-bit Office 2010

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.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.