Is it possibke to extract import data from excel file not csv type

[Former Member]

I am getting training from somebody, who is telling me the excel file has to be type csv only to extract and import the excel data for creating infoobjects, is that true.

Please kindly provide steps, if any one has steps to extract the excel data while creating info object.

I am going thru an excersise for creating info objects, but while brining the excel csv file data to info objects do i again need to create each field column and its attributes etc.

Thank you all for the helpful info.

[Former Member]

Hi

You will have to convert the file into CSV format for importing the data from the excel file .You can check the options in the extraction tab for the Data source.

Regards

Rahul

[former_member223480]

Hello

You can't upload excel file within a datasource, you need to convert it to a csv or a tab delimited file.

Check the following post

[;

Thank you

Yiannis

[Former Member]

Hi

If you want to load data from excel to BW(Info Objects or data source), then file should be in excel format. to import the data system directly import it into excel sheet(normal one)

to load the data you should have all values and attributes in your excel sheet which you have created in BW system.

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/4096b8fc-6be7-2a10-618e-b02a5e5e7...

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a0a556c6-f9e6-2a10-b58d-c68e42c26...

check the above two, those are very useful

Regards,

Venkatesh