I installed office 2010 on SharePoint server running with standard edition. When I wanted to open Datasheet view of a list it shows like this.
- A datasheet component compatible with Windows SharePoint Services is not installed.
- Your Web browser does not support ActiveX control.
- Support for ActiveX controls is disabled.
To fix this problem I installed “2007 Office System Driver: Data Connectivity Components” from http://www.microsoft.com/downloads/en/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en
and it works fine now