Bulk insert problem.

[sgergely]

I have a problem with bulk insert.
I try to insert an .xls file to a database table, but I don't know what values should I put in the FIELDTERMINATOR and the ROWTERMINATOR. I tried almast every posible combination mostly this one:
BULK INSERT DBname..tablename FROM '\\cs_file\public\test\teszt_import.xls'
WITH (
DATAFILETYPE = 'native',
FIELDTERMINATOR = '\t',
ROWTERMINATOR = '\n'
)

I get the following error message:
Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.

[rmiao]

Try save it as .csv file.

[skhanal]

As RMIAO said use CSV, BULK INSERT does not work with non text files. If you must use XLS file, use DTS.

[sgergely]

Thank you for your help. I saved it as a CSV, so now it works.