converting ms access database to sql server database?

Posted by Anilkumar431 under Sql Server on 12/28/2012 | Points: 10 | Views : 1973 | Status : [Member] | Replies : 1
hi all,
i have one database file which is of ms access database(.mdb) . that i need to convert to sql server 2008 database(.mdf)...
please help me..


Posted by: Shipramaurya on: 12/28/2012 [Member] Starter | Points: 25

Hi @anil Kumar,

If you are using MS Access 2007 then you have this option available to move data from MDB database to Sql Server Database file..

1. Open your database (.mdb) in MS Access 2007
2. GO to Database tools tab
3. Click Sql Server..
4. A wizard will open That will guide you about the appropriate steps to perform..

@Shipra - S.M. Techie

Anilkumar431, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response