on 04-14-2008 9:18 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
79 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.