How to create a scheduled task for imported tables

[jennypretty]

Hello,
I successfully created imported database tables into MS Access database that import all tables from SQL Server database. I don't do the linked tables because I want to have a way to modify data from these imported tables that will not affect the SQL tables.
I am looking for a tool or a way to automatically run the import daily.
Is there a way or tool to do this job?
Thanks.

 

[madEG]

I use SSIS to import (part of SQL Server 2005) a file exported from a UNIX based DBMS into a table in SQL Server and it works great, and then have a SQL Server Agent do the scheduled work.

I am sure there are some ways to export from SQLServer and push into MS Access... on a schedule

See here http://blogs.techrepublic.com.com/datacenter/?p=205

I know this is excel and not ms access... but this link helped me cut my teeth on SSIS. Just chose the appropriate target (MS Access) and source (SQL Server) - and do the rest by these instructions.

Good luck.