Export from SSMS 2008 to MsAccess 2007

[suni_dotnet]

Hi, I have to shift my database from Sql Server Management Studio 2008 to MsAccess 2007 database. SSMS is not supporting .accdb extention (asking for .mdb extention) whereas my Access has .accdb extention. How can i export the database? Any procedure to convert from .mdb to .accdb in SSMS or .accdb to .mdb in Access. After googling a lot i tried creating DNS (i don't know its purpose), but is not working. Thanks in advance.

modified on Monday, September 21, 2009 1:27 PM

[Lost User]

* Go to the object explorer (from the menu "View", "Object Explorer") * Go to the "database" node of the treeview and select your database. * Right-click the node and select the item "Tasks" and from there the subitem "Export Data". * Click next, and select the database from SQL Server that you want to export from. * Click next, and select "Microsoft Access" as your destination. You'll probably need an existing database. * Follow the wizard until finished with exporting :)

I are Troll :)