Sending Data from MSAccess to R/3

[Former Member]

Hi All,

We have Database system of type MSAccess in our Landscape. Here I need to Send production Details from MSAccess to R/3.

I Dont KNow exatly that we could fetch Data from MSAccess or not.

Pls let me know Whether we can fetch Data from MSAccess or not.

If possible Pls let me know the step by step procedure that I should follow.

Any inputs will be appriceated

Thanks

Ravi

[former_member556603]

Hi Ravi,

Fallow the Following Blogs..

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

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

For Example:

Open the receiver to specify the Connections with the Database

Database Connection

JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection jdbc:microsoft:sqlserver://SQLSRV:1433;DatabaseName=J2EE

User Name (Specify your User name)

Password (Specify your Password at two columns)

Note : - Here J2EE is the Database name

Reward points if it is useful

Thanks,

Satya Kumar

Edited by: SATYA KUMAR AKKARABOYANA on Apr 14, 2008 10:28 AM

Edited by: SATYA KUMAR AKKARABOYANA on Apr 14, 2008 10:30 AM

[Former Member]

Hi,

Check this Example, how can we pick the data from MS-Access DB

We have to mention the following details in case of Ms-Access-XI-

URL:jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/XI/Workspace/xi_input.mdb

Jdbc Driver: jdbc.odbc.JdbcOdbcDriver

or

URL: jdbc:odbc:<DSN Name>

Jdbc Driver :sun.jdbc.obc.JdbcOdbcDriver

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

Regards

Seshagiri