MS Access In XI

[former_member510662]

Hi Gurus,

I am facing a problem with my scenario.

My scenario is need to transfer data from a MS Access Database, which is running on a local mechine, windows platform to XI ,which is in Linux platform. My problem is how can we access the Ms acces file in XI, and what is the driver name i have to give in the sender adapter Please help me

[Former Member]

Hi,

We have to use the Following drivers in case of MS-Access

JDBC Driver: sun.jdbc.odbc.JdbcOdbcDriver

Connection: jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\path\demo.mdb

Check this for Connecting to MS Access using receiver JDBC Adapter

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Reward Points if Helpful

Regards

Seshagiri