Data exchange XI <--> MS Access / Visual Basic Application

[former_member301120]

Hello to all,

I've got the issue to connect MS Access with SAP XI in order to read data out of SAP R/3 into MS Access.

Is there any how to guide.

Which is the best way to connect MS Access or any other Visual Basic application to XI.

Thanks for your help.

Regards Christian

[VijayKonam]

> I've got the issue to connect MS Access with SAP XI in order to read data out of SAP R/3 into MS Access.

>

You may use JDBC adapter to connect to MS Access but you would have to deploy the database drivers in XI.

> Which is the best way to connect MS Access or any other Visual Basic application to XI.

I would prefer to have file adapters for this integrations. Generate files from MS Access db and send to XI. If it is other way round, consume the flat files generated by XI and use them in your VB applications.

VJ