After installing SharePoint 2010 all by myself(it was a great experience 🙂 ), tried working on creating sites and creating lists. The server that I installed SharePoint 2010 did not have office installed. I created a list and wanted to push in data in datasheet view and unexpectedly I got the below error… As usual did not panic and went and knocked Google’s door…
How to solve this?
Download 2007 Office System Driver: Data Connectivity Components from this link
If you refresh the page and click on Datasheet View, you will see what you expected to see.