Well, an SSIS package is one way.
answered Oct 09, 2009 at 10:53 PM
From SQL Server you could have the SQL Server Agent execute an SSIS package or even simply use a linked server to Access and put the data in Access from straight SQL. I would prefer this method if your use of Access is as a data transport mechanism, and if you have good control over your SQL Server environment.
Although Access does not have built-in scheduled automation like the agent, you can also have Access pull data using a linked table to a table or view in SQL Server. I would prefer this method if you already have a lot of code in Access or your rights to administer SQL Server is limited.
There's always the option of writing something externally in just about any other platform.