A couple more ideas.
1 - When I was doing Oracle work in a past life, the TOAD utility had the ability to turn a record set in a data grid to a bunch of SQL INSERT statements.
This is definitely slower than BCP.
2 - Use the import export utility, which is a wizard utility tool, to create and run a simple SSIS package. This uses bulk copy operation under the hood.
Many other ways can be listed, but the import/export and bcp utilities come installed out of the box.
John Miner
Crafty DBA
www.craftydba.com