topic Re: data upload in Application Development and Automation Discussions

data upload

Former Member — Wed, 15 Apr 2009 09:29:47 GMT

Hi,

I have a certain requirement that I upload master data from a Excel spreadsheet into SAP (using LSMW).

I have a query if there is any row limitation (of 65000max lines) to upload from excel at a time.

I have a huge data upload.

Please help.

Thanks.

Former Member — Wed, 15 Apr 2009 09:31:27 GMT

Yes, there is a limitation for number of records from Excel side.

Instead of excel , use a CSV file or a text file.

Regards,

Ravi Kanth Talagana

Former Member — Wed, 15 Apr 2009 09:35:59 GMT

Thank you very much for the clarification.

But the according to the requirement the i/p file is in excel only.

So is there any way to handle this issue during upload or the only way is that the file be split (not desirable in my requirement).

Thnaks.

former_member203501 — Wed, 15 Apr 2009 09:36:30 GMT

hi look at the following post ....hope it will helps you...

Former Member — Wed, 15 Apr 2009 09:58:30 GMT

Thanks for the replies

But if there is a way to handle excel file with this issue please suggest

Edited by: Barnita Saha on Apr 15, 2009 11:58 AM

Former Member — Wed, 15 Apr 2009 10:17:04 GMT

Hi,

Excel 2007 can handdle more 1 000 000 lines.

Issa

former_member203501 — Wed, 15 Apr 2009 10:24:54 GMT

hi see this ...

this is helpful for u i hope.....i am not sure for this..