Recurring Automatic Import from a SharePoint

[Cacsus]

All,
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!

[MMcCarthy]

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.

Mary