Link Access 2007 to SharePoint 2007 Survey
So here is my problemo. I am trying to organize site requests into a system that will let us easially see what requests have come in and who are the particular owners or users associated with the requests. Currently we use a SharePoint 2007 Survey to collect all the requests. I was hoping to upgrade things by linking the Survey list to an Access 2007 db so we can manage the data better. However, whenever I attempt to link the Access DB to a SharePoint list, none of the survey lists show up. I was wondering if there was a way to make it so whenever someone completes a survey, it updates the Access DB. I have figured out a way to get this to work with InfoPath but I would rather use the surveys that already exist. Thank you, Jeb G.
August 11th, 2010 10:36am
This can be done through various methods without using InfoPath. Below are the URL's which could be helpful for you to link the Access Database to the SharePoint List http://office.microsoft.com/en-us/access-help/introduction-to-integrating-data-between-access-and-a-sharepoint-site-HA010131463.aspx http://office.microsoft.com/en-us/access-help/import-from-or-link-to-a-sharepoint-list-HA001230313.aspx http://sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/Post.aspx?ID=68Fred Ellis - MSFT - "Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread."
September 5th, 2010 10:09am
But the problem here is that surveys don't show as lists correct? They don't display as a 'normal' list within Access and therefore can't be linked via conventional methods. Is there a method to gain access to the survey list?
September 20th, 2010 11:27am
Any solution yet to this problem? linking access 2007 to a sharepoint survey?
November 30th, 2010 11:34am
Import from or link to a SharePoint list http://office.microsoft.com/en-us/access-help/import-from-or-link-to-a-sharepoint-list-HA001230313.aspx Note You cannot import surveys or discussions. Note You also cannot link to surveys or discussions.Fred Ellis - MSFT - "Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread."
November 30th, 2010 12:30pm
You can create a link to a SharePoint survey using VBA, Please see: http://answers.microsoft.com/en-us/office/forum/office_2007-access/access-2007-link-sharepoint-survey/567909e4-25c2-4ecb-901a-dbd49e773e43 -Jay
May 3rd, 2012 12:29am