Importing MS Access 2007 table to SQL 2005 [closed]

Closed. This question needs debugging deta开发者_Go百科ils. It is not currently accepting answers.

---

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 7 years ago.

Improve this question

Greetings, I want to import MS Access 2007 table to SQL 2005. I followed this link: http://www.fmsinc.com/MicrosoftAccess/SQLServerUpsizing/importing/Import_Access_DB.asp I did everything the same but I get the following error when doing final step:

    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)

can someone please help me with this? what am I doing wrong?

---

Why not use the Microsoft SQL Server Migration Assistant?:

Microsoft SQL Server Migration Assistant for Access v4.2

SQL Server Migration Assistant 2005 for Access V4.0

Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from Microsoft Access to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. SSMA 2008 for Access also supports migrating to SQL Azure.