how to convert sql server database to access database
 

Hi
I want to convert Sql Server Database to Access Database ,


I have one database and it has different tables and view also.

please help me how to do this ?

Re: how to convert sql server database to access database
 

Make a new Access database. Go to the tables tab and right click in the large whitespace area. Select Import. You'll need an odbc connection to your SQL database. You can import all of your tables at once.

For your views, I would try copying and pasting the views SQL into queries. I don't think it will work to import them as queries, and there will probably be some differences in the SQL between Access and MS SQL.

galaxygal

Re: how to convert sql server database to access database
 

Thanks
It works :)

Re: how to convert sql server database to access database
 

Additionally, if you have to perform this task any more, its quite easy to build a SSIS package to do it for you. That way having a fresh new Access DB is only a click away.

Re: how to convert sql server database to access database
 

Thanks