Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

how to acces sap data using ms access

Former Member

‎2008 Jul 09 8:44 AM

0 Likes
483

hi,

i have a requirement . i need to access data from sap tables using ms acces. i need to do programming in ms access. can any body

guide me in this regard

regards

siva

hi,

i have a requirement . i need to access data from sap tables using ms acces. i need to do programming in ms access. can any body

guide me in this regard

regards

siva

Reply
2 REPLIES 2
Read only

Former Member

‎2008 Jul 09 9:00 AM

0 Likes
432

Hi

You will need an SAP driver to establish the connection from Access. Once that is done, you should be able to "link" to the SAP table of choice. This can be done using a "wizard".

May be this link will help you..

http://it.toolbox.com/wiki/index.php/How_can_I_upload_data_to_SAP_and_download_data_to_Excel%3F

Regards

Sowmya

Read only

Former Member

‎2008 Jul 09 9:04 AM

0 Likes
432

Hi

Using ODBC you can set up a connection to the oracle database. You can then link to the tables directly. You can use Acces make table Query to retrieve the data directly into anothe table using the link. You can also use SQL Pass Thru which use all the time.

Regards

Divya