Accessing MS access databases using PI

[trinadhreddy_nallamilli]

Hi Experts,

I have two MS access data bases, what are the drivers need to be installed on PI .Operating system of PI is windows NT. I need to retrieve these two data bases at a time  to  place file in AL11 of system. The two  data base tables having similar structure. IS it possible with a simple JDBC to  FILE scenario?

Regards,

Trinadh

[smavachee]

Hello Trinadh,

Similar thread at.. Integration with MS Access

Also look for

Hope it helps.!

Regards,

Sunil

[Former Member]

HI ,

JDBC to file only;

Please go through the below link for better clarity.

http://scn.sap.com/message/9796158

Link for downloading MS ACCESS driver.

http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html

Regards

Venkat