Community
Application Development and Automation 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: 
Read only

Excel to Internal Table

Former Member

‎2006 Dec 14 6:23 PM

0 Likes
650

Hi ,

I am trying to Upload GL accounts From EXCEL to INTERNAL TABLE Using ALSM_EXCEL_TO_INTERNAL_TABLE function module .

The problem i am facing is Some Junk data is being Uploading including with Records i maintained in the Excel . Could you please guess what might be the problem for this ?

Thanks in Advance.

Srinivas

Hi ,

I am trying to Upload GL accounts From EXCEL to INTERNAL TABLE Using ALSM_EXCEL_TO_INTERNAL_TABLE function module .

The problem i am facing is Some Junk data is being Uploading including with Records i maintained in the Excel . Could you please guess what might be the problem for this ?

Thanks in Advance.

Srinivas

Reply
5 REPLIES 5
Read only

Former Member

‎2006 Dec 14 6:27 PM

0 Likes
620

Not sure about this, but why dont you suse GUI_UPLOAD? You shouldnt have any problem reading the file and loading it into your internal table.

- Guru

Read only

Former Member

‎2006 Dec 14 6:46 PM

0 Likes
620

Hi Srinivas,

Did you check the excel sheet correctly, I mean scroll the bar completely to the right and also check vertically, coz sometimes you get the excel sheet from some one and they might have entered some data unknowingly. I would advice you to check the excel sheet.

Regards,

Vivek

Read only

Former Member
In response to Former Member

‎2006 Dec 14 7:02 PM

0 Likes
620

Hi Vivek,

The same Excel file is bing uploading properly from Other workstation ( Desktop) , Its not working from my Desktop . Definitely nothing wrong in the Excel file . I think the problem with MS EXCEL ( Macros missing ) . I Could not fix the problem . Please somebody let me know the problem exactly .

Thanks

Srinivas

Read only

Former Member

‎2006 Dec 14 6:50 PM

0 Likes
620

Hi Srinivas,

Welcome to SDN.......

Use function module <b>'TEXT_CONVERT_XLS_TO_SAP'</b> to upload excel document into internal table.

For the reference of code,Check this link.

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

Thanks,

Vinay

Read only

Former Member

‎2006 Dec 14 7:21 PM

0 Likes
620

Hi,

Check your processes to make sure that another instance of excel isnt running in the background. If the excel file is the same on another workstation and its only your workstation not working I would suggest a reboot.

Warren