title: Importing MS Access 2007 table to SQL 2005
body: <p>Greetings, 
  I want to import MS Access 2007 table to SQL 2005. I followed this link: <a href="http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp" rel="nofollow noreferrer">http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp</a>
  I did everything the same but I get the following error when doing final step:</p>
  
  <pre><code>    Could not connect source component.
  
  Error 0xc0202009: Source - TestTable[1]: An OLE DB error has occurred. Error code: 0x80040E37.
  
  
  Error 0xc02020e8: Source - TestTable[1]: Opening a rowset for "`TestTable`" failed. Check that the object exists in the database.
   (SQL Server Import and Export Wizard)
  </code></pre>
  
  <p>can someone please help me with this? what am I doing wrong?</p>