DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
Sql Server Bulk Insert
// description of your code here
BULK INSERT TmpStList FROM 'c:\TxtFile1.txt' WITH (FIELDTERMINATOR = '","')
if it is a normal text file where (say) phone numbers appear one on each line, then
BULK INSERT TmpStList FROM 'c:\TxtFile1.txt'