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?