Question: how to export data from sql server 2008 to ms access 2007?
Answer: Open SQL Server using the credentials.
Select the database to be converted.
Right-click the required database and choose 'Export Data…' from the 'Task' option.
Select the Server name from where the database is to be exported.
Specify the 'Authentication', either Windows or SQL Server Authentication.