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.

Is it possible to convert sql database into access database?

Answers (7)