How to import and export bulk data using Bulk Copy Program
BCP means bulk copy program, is a simple command prompt utility in SQL server. It is a very strong tool by which you can import and export millions of records from text files or DAT files to SQL server or vice versa