Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to extract data from SAP
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to extract data from SAP
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to extract data from SAP
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Excel to extract data from SAP
We have SAP at work and there is an option to save query results in xls file -- duan ----------------------------------------------------------------------- duane's Profile: http://www.excelforum.com/member.php...fo&userid=1162 View this thread: http://www.excelforum.com/showthread.php?threadid=26950 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract data after a find in Excel 2003 | Excel Discussion (Misc queries) | |||
Paying fee to someone who could extract data from web-page to excel! | Excel Worksheet Functions | |||
vba code for excel to extract data from txt file | New Users to Excel | |||
Extract MS word data to MS Excel | Excel Programming | |||
Extract data from SAP to Excel? | Excel Programming |