View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Extract data from SAP to Excel?

Hi
SQL won't help you as it is not recommended to access the SAP tables
directly with SQL!
So several ways to tackle this (though you might better ask this type
of questions in a SAP user group). One way:
Create a SAP function module which gathers your data:
- This should be accessible by VBA (SAP provides sample code for
accessing this with VB, C, C++)

So again: Don't use SQL on SAP's internal data tables :-)




--
Regards
Frank Kabel
Frankfurt, Germany

Gunner wrote:
Hi,

Have anyone any recommended sites for this?
I were thinking of using SQL and not send keys in VBA?

However, any tips for this is highly appreciated!

Sincerely,

Gunner