Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 export from SSMS 2008 to MsAccess 2007

Author  Topic 

suni_dotnet
Starting Member

2 Posts

Posted - 2009-09-21 : 13:36:49
Hi,
I'm not sure its the correct forum. sorry for inconvenience.

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.
   

- Advertisement -