We have a manual process that we do on a SharePoint list to export data from SharePoint to a spreadsheet that can then be used by non SharePoint programs. I'd like to be able to automate this process so that it can be scheduled as a Task to run on
a daily basis. Not sure if a workflow can do what I'd like it to. I have SharePoint Designer 2007 as well.
Here are the steps:
1. Load a particular View of a SharePoint List
2. From the view's Action menu, "Open with Access"
3. Save the resulting Access database as a file to a specific Folder on the computer hosting SharePoint
This would be run as a Task on the computer hosting SharePoint.
View Complete Post