SAP Query From Excel/Access through SAP-DB ODBC

Posted on 2006-04-14
Last Modified: 2013-12-08
Dear All,

I'm trying to query SAP from Excel/Access through ODBC (SAP DB), directly from VBA. I just specify that I never used SAP before. Some questions:
-  I need special authorization to query SAP using ODBC (Read-Only)?
- There is a way to find from the standard SAP interface Server & Database I should use logging in from SAP-DB ODBC Interface?
- There is a way to find a list of SAP table and content?

- There is someone who have already an example of VBA basic code interfaced with SAP?

Thanks a lot for the support,
Question by:Giangyp78
    1 Comment
    LVL 10

    Accepted Solution


    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Suggested Solutions

    Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
    Read about achieving the basic levels of HRIS security in the workplace.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    754 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

    20 Experts available now in Live!

    Get 1:1 Help Now