Is it possible to convert sql database into access database?

Question

How to create sql database into access database?

rahul Gupta · Answer

Hi MS provied very good utility Import/Export.

Anil Kumar · Answer

Sam's suggestion is best. No need to use third party tools or waste time in write programs. Microsoft already provided an easy option for import/export.

Sairam · Answer

Create a Access Database script for ur database and execute that script in sql sever management studio

Vilas Gite · Answer

hi Shree Using Access - MS Office 2007 I am not sure but Please try External Data Menu and Import ODBC database (Import or link to an ODBC Database such as SQL Server).

Shalini Juneja · Answer

you can convert sql database into MS Access by database converter application program and also from database converter tool.you can find these tools in below given site links http://www.access-file-repair.com/database-repair/mssql-to-ms-access-database-conversion-tool.html http://www.accesspasswordrecovery.us/accesspasswordrecovery/mysql-to-access-converter.html http://www.db-convert.com/ http://dbconvert.com/convert-access-to-mssql-pro.php hope these will help you.

Sam Hobbs · Answer

Execute Access. Go to the help for Access. Type import in the search box. Do you see the topic Import or link Access to SQL Server data? I think that will help. If that does not help then perhaps I misunderstand the question.

Amit Choudhary · Answer

Hi friend If you are not using the sql express edition then there's an option to Import/Export to other types of database sources like Excel/Access or any other odbc database.