I've used SQL Server DTS successfully, so I'm sure the SSIS packages are just as nice. I've also used the SSMA for migrating Access, fairly clean interface also.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------