Using the bcp Utility
The bcp bulk copy utility can be used to insert large numbers of new rows into Microsoft® SQL Server™ tables. The utility requires no knowledge of Transact-SQL, but users must understand the structure of the tables into which the new rows are being copied, as well as the types of data that are valid for the rows in the table.