BULK INSERT 0 rows affected

[Dimitrie1]

I have a csv file and am trying to insert it into a table
it doesn't error it just says 0 rows affected. I am signed on to SQL with SQL Authentication

BULK INSERT database.dbo.table
   FROM '\\Studebaker\itpmdocs\Business_Proc\Cheque\Test_Subsequent.csv'
with
(
firstrow = 2,
fieldterminator = '\t',
rowterminator = '\n'
)

 

[timfoster]

Without seeing your file it's impossible to say what the problem might be.

Post your csv file

 

[bborissov]

If the file is CSV why the field terminator is TAB?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[Dimitrie1]

I can't use comma delimited because there is commas in the data. I was able to get my code to work when I created a tab delimited text file and removed the double quotes it added.

thanks for your help.