Today I had a need to import an old Access database into Sql Server 2005. First I tried with Sql Server Manager Import function but I quickly gave up on it as it was yielding many errors for some reason. Next I googled for a solution and found that MS is giving SQL Server Migration Assistant for Access (there are versions for other source databases) which is a full blown application that lets you configure many import parameters, mappings and other useful stuff.
It worked like a charm for me.
its good