Sure you could but I would use SSIS instead. If it is a one-time event just right-click on the database in SSMS -> select All-Tasks -> Import Data and the Wizard will walk you through it. If it is a multiple time thing you can still use the wizard just save the package and then you can schedule it.