Sometimes it’s easier to work with your SharePoint list data in Excel or Access. Click on the list name from either the Quick Launch or from the All Site Content page. Select the List tab on the ribbon (SharePoint 2010). Toward the right, in the Connect & Export group, you’ll see an Export to Excel and an Open with Access. Export to Excel will let you use Excel’s robust tool set to pivot, chart, filter and otherwise analyze your list. Open with Access will let you run reports and create forms to enter and search information.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/33062/sometimes-its-easier-to-work-with-your-sharepoint-list-data-in-excel-or-access "