Skip to Content
0
Former Member
Jul 04, 2011 at 04:47 AM

Excel file format in OPEN DATASET

4428 Views

Hi,

I am trying to download file from SAP appl server which is written with '.xls' extension using OPEN DATASET in TEXT MODE ENCODING DEFAULT.

The problem is after download although the file appears in excel, the format of the same is not an EXCEL file but TEXT Tab delimited (You can find this when you try to FILE->SAVE AS)..

Is there anyway that we can download the file from SAP appl server in actual EXCEL format? Even OPEN DATASET in BINARY MODE didn't help me either...Pls guide. Thanks.

- Swaminathan R