Using Excel to extract data from SAP

[Jim]

Has anyone used Excel (via OLE I imagine) to extract data from SAP ?

At this stage am wondering if it is possible (I'm sure it is) and how
complex it is ?

Regards, Jim.

 

[Guest]

Hi
AFAIK this is not really possible. SAP provides other mechanismn to use for
this (e.g. Function calls in BAPI, etc.)

 

[keepITcool]

It depends.. SAP comes in many variants.
IF your company has SAP DB it would be no problem.

Contact the database manager (or your SPA consultant)
and ask!



keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Frank Kabel]

Hi
SAP could use a variety of databases but IMHO it would not be a good
idea to connect to this database directly as SAP does not ensure an
unchanged database structure through release changes.
To stay release compliant one should always use other mechanism to
transfer data out of SAP (and most companies I know prohibit direct
access to the database)

 

[duane]

We have SAP at work and there is an option to save query results in
xls file