Dear friends,
When migrating Office Access 2003 DB to SQL Server 2008 R2 using the SQL Server migration assistant for Access tool, the following error message is displayed; "Required MDB file is not loaded"; and I couldn't get the list of tables and queries
to be migrated. Any one with such a problem earlier and a solution for that?
I am sure the tables used are indexed. I confirmed that by creating a new database with indexed tables also yet proving no success.
I do not want to use the upsize wizard avaialble in the MS access(because I am analysing all the possible ways of transforming the data).
I am expecting a solution to be migrate the data from access by using SSMA. Can someone please help on this?
I have a sample DB and tables created by me.
Regards,
K.G. Manivannan
Go to the complete details ...