Load .XLS file into BW

Hi Harish,

its flat file loading.. about XLS no idea.

if possible, save file into CSV format, try to load using info pack,

as CSV format

you need to give, coma separated value and delimiter.

header rows to be ignored : 1

regards

As i know, we load data into Bw in two formats,

1. CSV

2. ASCII

regards

Hi Harish,

For CSV format at infopack external tab screen

provide these details

File name:

Fily type:

Data Separator

Escape Sign

Number of header rows to be ignored 1

regards

You can load XLS files in BW 7.3 or higher, but the file should be in your PC, not in server.

Hi Harish,

you can laod XLS files in BW 7.3 version.

Adaptor- load microsoft excel file (XLS) from local work station.

File name - xxxx

sheet to be extracted- xxxxx

header rows to be ignored- 1.

Thanks,

Phani.

Hi,

Loading the XLS from flat file will be availble from 7.3 or hiher version,

give the file location path etc...and also there is option for selecting perticular sheet from excel sheet as well.

Regards,

Chandra.

Hi harish,

Before creating the datasource on the top of the .xls flat file, write one dataset program to convert the .xls to .csv file and then create the datasource on the top of this .csv file.

DataSet program to load the data from .xls to .csv will have more complexity, because in my previous we have faced this situation.

Directly we can't create datasource on .XLS file.

Hope u got it,

You can upload Excel sheets without converting it first to CSV.

Go to your datasource, extraction tab:

Choose 'Load Microsoft Excel File (XLS) from Local Workstation'

Select the file name and the sheet to be extracted. These should be stored onto your local machine.

Next, create an InfoPackage and it will automatically select the file to be extracted as setup in the datasource.

I think first of all you need to convert your .XLS file to .csv and store it on the application server.

There is a FM FILE_READ_AND_CONVERT_SAP_DATA which can read data from .XLS file BUT ONLY FROM A PRESENTATION SERVER(but still double check on this).Pass 'XLS' to I_FILEFORMAT.

This FM will put the contents of your .XLS in to a internal table, which you can write to a .csv file easily using DATASET.

Yes its possible in BW7.3 versoin to load the flat file of type .XLS.

You can check the FM SAP_CONVERT_TO_CSV_FORMAT

Regards

KP