Hi, ive managed to get the following command to work but i had to remove the "go" commands that i usually use in the string when im SQL server. Could someone please clarify why i needed to get rid of them??
Code:
string strImport = @"BULK INSERT CSVTest FROM "DataFile"
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
SELECT *
FROM CSVTest
";
