How to migrate the Access database to MOSS 2007 sql server with the use of SSMA (sql server migratio
- by pointlesspolitics
Hi,
One of my friends got the access database with Forms (VBA) and wish to migrate all the database table to the newly installed MOSS 2007 site.
He is using SSMI for this purpose. He cannot do it because there are plenty of errors and warnings. I think it is due to the old Access queries.
Is there any other way to import the database to sql 2005 from access ?
Thanks