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

Snippets has posted 5883 posts at DZone. View Full User Profile

Sql Server Bulk Insert

07.08.2009
| 2748 views |
  • submit to reddit
        // 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'