Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to connect SAP to MS Accesss

Former Member
0 Kudos

Hi,

Can any one tell me How to Connect SAP to MS Access.

Hoe to fetch the data from MS Access from SAP

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Please try OLE for this. For identifying proper methods of MS Access that you need, try recording macros in it.

Thanks,

Renjith.

4 REPLIES 4

Former Member
0 Kudos

Hi,

Please try OLE for this. For identifying proper methods of MS Access that you need, try recording macros in it.

Thanks,

Renjith.

0 Kudos

Hi,

Using OLE u can access it.

Chk the macros available in MS ACCESS.

Open Any MS Access or word document .

Goto tools->macros->visualbasic editor->view->object browser

Regards,

Lakshman.

0 Kudos

yes.

my issue is i want to connect MSAccess from zprog . i want to fetch the data from access and the same time updation also

Former Member
0 Kudos

Hi,

Please see following link,

https://wiki.sdn.sap.com/wiki/display/Snippets/ReadingdatafromMSAccess+table

Thanks & Regards,

Shreemohan