excel and lsmw

[Former Member]

Hi

My source structure has five fields. And excel file has data distributed

in five columns. in the specify files step I have set tabulator as field

separator, but after reading excel file< lsmw returns something wrong.

And read rows count is more than data rows in the excel file.

What to do to read data from excel correctly?

[Former Member]

you can't read from excel. you have to convert your excel file first to a .csv file

[Former Member]

I couldn't solve this problem almost 2 hours.

Thank you very much.