Normally in SharePoint if you want to edit a list or library in a datasheet the machine you are using has to have Microsoft Office installed.
But what happens in cases where machines aren’t going to need Microsoft Office otherwise? It seems a little silly to purchase a copy of Microsoft Office just to have the ability to edit in a datasheet with SharePoint.
The solution is to download and install Access 2007 Runtime from Microsoft which is a free download. So now all client machines can have the functionality of using the ‘Edit in Datasheet’ feature without having to purchase an additional Microsoft Office license.
