exporting data from table in sql server to access?

Greetings

i wana know how can i export data from a table to access through a sql job

i am开发者_开发知识库 using sql server 2008 and office 2007

---

you can use SSIS "SQL Server Integration Service" For your problem. also you can job SSIS Application in sql server.