Import Sharepoint list to Access
Posted on 2012-12-24
I tried to import the data from sharepoint to MS Access using below steps.
External Data->SharePoint List->Link to the data source by creating a linked table->chosen from list->Ok. After importing ,when i tried to open the linked table it is giving message as
" The Microsoft Office Access database engine could not find the object ' name'.Make sure the object exists and that you spell its name and the path name correctly." If i open in desgin veiw then i am able to see the FieldNames but i cant see the datasheet view. I have only Read permissions for that particular sharepoint file. Is there any other way to import the data in to access and always connect thru online?