Import Eport Access 2007 .accdb files (dbForge Studios)
This feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html
-
Scott commented
I've been reviewing a few SQl tools and Studio is VERY useful except for the import. The current import is dissapointing when compared to the other NICE features. I admit, if we didn't need to import Access files then Studio would be perfect (I can create dbase in Access faster/easier than MSSMS then import...the tools in Studio would replace that method). Still...the Studio import is worse than any...including Microsoft free tools. It needs to import all tables/views at once including PK/FK relationships.