Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Excel format

Former Member

‎10-18-2008 8:59 AM

0 Kudos

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.

2 REPLIES 2

Former Member

‎10-18-2008 12:03 PM

0 Kudos

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

‎10-18-2008 3:07 PM

0 Kudos

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.