Import Sharepoint list to Access

keschuster
keschuster used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

I don't know much about Access but chances are that you need more than just SharePoint read permissions to open the list in the Access interface.

Try with an account that has at leas t "Contribute" access, i.e. read, wrie and delete permissions.

Cheers, teylyn

Author

Commented:
I have tried with "Contibute" access also. Still same message i am getting. If i try to import another list from sharepoint then i am able to import. i think it is happening only for one particular list. How can i import the data? It is creating table " AutoCorrect Save Failures" stated failure reason as " Could not save the Object"
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
<< AutoCorrect Save Failures" stated failure reason as " Could not save the Object" >>

Try turning off AutoCorrect in options and see if it imports then.

Autocorrect can be a pain sometimes.

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial