I'm trying to load data from a .txt file into SQL Server using the following:
BULK INSERT tblHours
FROM 'c:\test.txt'
WITH
(
FIRSTROW = 2,
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
My text file contains:
HourId,HourCnt,WorkDt,ProjId,TypeCd
1,2,'2005-07-30',3,'COMP'...