title: Converting Northwind 2007 to SQL2005 Database
body: <p>I have recently downloaded the Access 2007 Northwind example database and would now like to convert the database into a SQL 2005 database. I am using the Developer Edition of SQL 2005 and not SQL Express.</p>
  
  <p>I installed the Office 12.0 Access Database Engine OLE DB Provider drivers for working with Access 2007.</p>
  
  <p>So far I have 'created' a new database, gone to 'tasks' > 'import data'.</p>
  
  <p>At this time, the SQL Server Import and Export Wizard dialog shows, I select the 'data source' as Microsoft Access and have browsed to the file which I then select. I click next and now SQL Server displays the following error:</p>
  
  <blockquote>
    <p>Unrecognized database format Northwind2007.accdb.</p>
  </blockquote>
  
  <p>Has anyone successfully imported this database into SQL? Also, does anyone know what the differeces are of the .accdb file format and the Access 2003 .mdb format?</p>
  
  <p>Thanks for your input.</p>