Skip to Content
avatar image
Former Member

Access MS Excel from XI

Hey guys

is it possible to transfar data from MS excel to BW in the form of CSV,i know i will use File adapter with FCC on BW side but what adapter should i use to access data from MS Excel?

thanx

ahmad

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 29, 2006 at 06:34 PM

    Ahmad,

    It is not possible to read from excel with the help of file adapter. You have to develop an adapter module for this. Check this weblogs on how to read data from MS Excel:

    /people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

    /people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

    ---Satish

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2006 at 06:46 PM

    Yes, you need to develop adapter module for this or custom adapter. Some other group in my company has developed something like that before but I havent looked at what they have done.

    --Archana

    Add comment
    10|10000 characters needed characters exceeded