If you're just having a hard time because you're working on 2005 then here's the secret...  Right-click on the database name, choose Tasks, and then Import Data.