Use the SSIS Import / Export wizard or create an SSIS package by hand or use the BCP command line utility or the BULK INSERT T-SQL command.
The Import / Export Wizard can be found by right clicking a database and going to the sub menu under All Tasks.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"