Data Migration From MSAccess To SQL Express 2005

Hi ,

          I have a requirement to migrate the data from an existing MS Access database to a newly designed SQL Express 2005 database . Need less to say the table structures in both are totally different.I would like to know how can i handle  a scenerio where i want to map table A in access to table B in SQL express (the schema of both different and the number of columns can vary too) , how do i migrate the data from table A in Access  to Table B in SQL express using SSMA?

 

Also i would appreciate if some one can tell me is SSMA the right tool for this , or should i use  the upsizing wizard of MS Access. The constraint here is that the data needs to be migrated to a completely new schema. I just need to migrate data only and no other objects.

 

Thanks

Mahesh