Hello - I saw this solution while searching for a solution to my current situation, which is somewhat similar.

Here's the goal: get a daily import of data (daily snapshoot) from a SharePoint list into ms access so that I can run advance reporting

Here's where I am:
  • Created an AutoExec to import the SharePoint data daily with 'Scheduled Tasks'
  • Named the daily import table "All_yyy_mm _dd" for each day
...