Sometimes we require taking back up of list items along with attachments. Definitely there is an option to export to excel, however that doesn’t copy attachment with it and hence it is a drawback only if you want attachment with list item as well, else export to excel is really a cool functionality.
Coming back to the point, so what do we do to get the attachment as well? Well, the answer to this question lies in the same menu and that option is Open with Access.
So go ahead with your list items that you want to back up. Open the Actions menu and click on open with Access.
Specify a new location for your database and also chose whether you want to be connected with SharePoint list so that any changes can be reflected here and also vice versa, or just you want to have a copy of it which is export the data.
That’s it. You have just taken a back up of your list items with attachments.
5 comments:
Thank you for this solution! I have been looking for a way to do this for months!
Thank you for this solution! I have been looking for a simple way to do this for months!
Thank you for this solution! I have been looking for a way to do this for months!
Great post. Works great with lists. Now if there was a way to capture the same information from a discussion area.
no idea about discussion area, but nice idea to explore.
will try to work on it, if get time.
Post a Comment