SAP Query From Excel/Access through SAP-DB ODBC
Posted on 2006-04-14
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,