Question: how to export data from sql server to access?
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...