Solved

Access SAP Connector

Posted on 2013-12-11
2
590 Views
Last Modified: 2013-12-11
Hi

Does anyone know of a means of getting SAP data into Access?

Thanks
0
Comment
Question by:murbro
2 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
Comment Utility
Depending on how your company views data access, you might be able to link directly to the SAP tables but in most companies, this is a non-starter so you have to get them to give you an extract or you have to be able to piggyback on one that is already happening.  Last time I looked, SAP tables were really difficult to understand.  The original application was created many years ago in a mainframe environment when all names were restricted to 8 characters and I don't think the older parts of the app have ever changed that.  The thing that makes it doubly hard is SAP was developed in Germany and the names are all German abbreviations so they are gibberish to English speakers.

Usually the extracts would be created as .csv files but you may have options.  Start with your desktop support people.  They will probably know who you have to get in touch with.
0
 

Author Closing Comment

by:murbro
Comment Utility
Thanks very much for the info. I have already gone down the .csv route and your answer validates that this is the best option. Thanks a lot
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now