Check out the DTS (Data Transformation Services) in SQL Server. It allows SQL Server to import large amounts of data relatively fast from various data sources. Once you start moving data around between different databases, it's well worth the time spent learning to use this tool.

Kurt