By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,935 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Recurring Automatic Import from a SharePoint

P: 1
I have a need at work to pull form history from a SharePoint form library on a nightly basis without the worry of human reliance, in case someone calls out sick or forgets. How can I setup Access to pull this external SharePoint data nightly, say around 9pm?

I have only a slight knowledge of databases, that is to say I know what they are and have become a novice user of Access, so I ask for forgiveness of my ignorance. I am starting core classes soon in OUP on databases so I am sure I would know the answer in about a year, but not right this moment. I appreciate the tolerance on my lack of knowledge.

To throw another wrench in this I have started bench testing Vista for our group, with IT's watchful eye, and have Access 2007 installed. I can switch to another computer and load up Access 2003 if that would be better or more relevant to instructions given.

Thank you in advance for any direction!
Mar 15 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
Your problem is Access would have to be open to run any imports. This means you would have to schedule Access to open at 9.00 pm and set the code to run in the On Open event of the startup form.

Mar 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.