Is it possible to convert sql database into access database?

Hi,

MS provied very good utility Import/Export.

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.

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). 
 

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.

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.

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.