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
Click through for several tips around BULK INSERT.