Excel to a Flat file Connection

[Former Member]

Hello,

I have a requirement to send the data from Excel to a flat file at the other end.

To upload the data from Excel to the outbound interface, I am using the JDBC Adapter.

But, in the Integration Directory, while configuring the JDBC adapter, it is asking for the JDBC Driver as well as the connection.

What should I need to give for the Excel? Where do we check for the JDBC Driver and Connection for an application like Excel or MS Access?

A quick solution for this would be highly appreciated.

Thanks a lot, in advance.

Priya

[Former Member]

Hi Priya,

You can do with simple file adapter using module processor.

see this weblog...

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

Thanks,

sekhar

[former_member206604]

Hi,

For converting excel either Conversion Agent to do that or you can use adapter module. If you are looking for a adapter please refer to this post, here you get the complete code for converting Excel file into XML payload.

Thanks,

Prakash

[MichalKrawczyk]

hi,

via jdbc

you can try this one:

https://xlsql.dev.java.net/

or you can use itemfield conversion agent

no jdbc just another tool to get data

from excel files word etc to the XI

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>