I have used the following syntax

bulk insert Ionia_ISmSv2_Office.dbo.tblJobsspare from 'c:\Scrap.xls'

with (DATAFILETYPE = 'char', fieldterminator = '\t',

rowterminator = '\n')

And then received the following error:

Server:...