Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : How to extract data from columns ? | Excel Discussion (Misc queries) | |||
vba code for excel to extract data from txt file | New Users to Excel | |||
Extract Data from Multiple Excel Files | Excel Discussion (Misc queries) | |||
Extract MS Excel Data embedded in MS Word | Excel Discussion (Misc queries) | |||
Extract data (not in table) from Word to Excel | Excel Discussion (Misc queries) |