Bulk Insert
I was trying to bulk insert some data, and I found a page that had this (don't have the link anymore), which I used it to get it to work:
BULK INSERT tblYLT
FROM 'C:\YLT.txt' WITH (DATAFILETYPE = 'char', FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n');
tblYLT was a table that I had already existing in a database, which I sucked in some data from YLT.txt. tblYLT already had the columns that would be inserted, and the sizes must be the correct size, or an error will occur. Also, don't have the header column in the file; they get sucked into the data. There may be a flag for this.