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 ";


Reply With Quote