Import excel file using bulk insert command

BULK
INSERT dbo.blk_testFROM '\\xlhealth.local\xlisdata\profiles\skeerthi\My Documents\yes.xls'
WITH(FIELDTERMINATOR ='|',
'ROWTERMINATOR = ')