SQL Server: Use BCP to import a text file
BCP allows you to quickly import a text file into a predesigned table in SQL Server. You need to run BCP, specify the table and the input file. Finally, you need a few switches: -T for a trusted server connection, -t for the delimiter, -c for char mode.