I am using the following code:

BULK INSERT csvtest FROM 'y:\1.csv' WITH (Fieldterminator = ',', Rowterminator = '', Firstrow = 1)

when in an asp page it simply does not execute so i copied it into the SQL server SQL query box and recieved the following error when i ran it:

Bulk Insert: Unexpected end of file (EOF) encountered in the data file

change rowterminator to something like "\n"