How to we import SAP data into EXCEl sheet

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
LavanyaRamesh007
Participant
Posts: 42
Joined: Mon Apr 21, 2008 1:49 am

How to we import SAP data into EXCEl sheet

Post by LavanyaRamesh007 »

How to we import SAP data into EXCEl sheet. In my job the source sap data needs to be taken into excel sheet. If i try exporting i am getting formatting errors.
Eg. I have 000.20031 -> is coming as 0.20031
since we cant convert the format as text when we try to export data, i am wondering how do i proceed .. Kindly help
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Who cares? It's the right value. You can format however you like once it's in Excel.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ashokkumar83
Participant
Posts: 13
Joined: Tue Oct 09, 2007 1:02 am

Re: How to we import SAP data into EXCEl sheet

Post by ashokkumar83 »

R u using the source as a sap abap stage? if that is the case.

open abap stage goto list (system) save as in to select the option excel.

so u can save the data in excel.



Regards,
Ashok
Thanks&Regards

Ashok kumar.V
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please use a professional standard of written English in DSXchange.

"R u" isn't.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply