Thomas Rushton performs BULK INSERT I imagine the way most of us do, through trial and lots of error:
Step one in solving these problems in SQL Server is loading the data into a database so you can do something with it.
I chose to use
BULK INSERT, because, according to the documentation, it:Imports a data file into a database table or view in a user-specified format in SQL Server
Ideal, right?
Click through for several tips around BULK INSERT.