Excel format

[Former Member]

I know how to upload data in txt file format to sap using lsmw.

I want to upload legacy data in Excel file format to sap using lsmw.

Then how to do this.

[Former Member]

Hi,

in step num 7 of LSMW we will specify the file name there you give your source and excel file and in the DELIMITER tab select the semi colon radio button. by this i think u will be able to upload data from an excel file in LSMW.

please correct me if iam wrong.

abaper007.

[Former Member]

Hi,

Save your Excel data file as a Tab-delimited text file on your local drive (C:\) and name it with a .txt file extension, and use it.