Extract data from SAP to Excel?
 

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

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