Question: how to export data from sql server to access 2007?
Answer: Right click on your database -> Task -> Export Data.
Choose your data source and database.
Click on next choose your destination database in destination combo select ms Access Database select file of Access database.
Click next: copy data from tables or views...