How to connect MSAccess with SAP-MII

[Former Member]

Hi All,

Can I know how to connect MS Access to SAP-MII and the procedures?

Also what are the Jar files to be deployed?

[Former Member]

Hi Parthee,

Please check the below thread:

Regards,

Pradeep

[Former Member]

Hi Pradeep,

Thanks for your Information.

But I require complete steps to connect to MS Access and how to get excel data in MII?

Can you help me out.

[Former Member]

Hi Partee

check this blog

/people/manisha.batabyal/blog/2010/02/23/how-to-migrate-microsoft-excel-data-to-ms-sql-database-in-mii-120

same as applicable to ms acess as well.

Just change the path to mdb file

You can use PCo for the same as well.

Thanks

Anshul

[Former Member]

Hi Anshul,

I tried that in PCO but the Agent instance not starting properly.

The Error log returns that .Net framework for ODBC is not installed.I also Installed that but even though same error was coming.

Can I directly try with the ODBC driver.which jar file is to be deployed?