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

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)

--
Regards
Frank Kabel
Frankfurt, Germany

"keepITcool" schrieb im Newsbeitrag
...

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


"?B?RnJhbmsgS2FiZWw=?=" wrote:

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

"Jim" wrote:

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.