Importing text files into tables in SQL Server database schemas can be done using different methods.
One method using SQL Server specific SQL is shown below.
SQL Script
If you want to use tab delimited source files you can type in the delimiter into FIELDDELIMITER using the tabulator key in SQL Server Management Studio.
BULK INSERT CSVTest FROM 'c:\csvtest.txt' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO