Extract table data from SAP using excel macro

[billyjo182]

So, I've tried and tried... I need to copy nested data out of a table that I can not seem to get, here is the basic code. I've tried many different ways and have failed miserably so i'm now looking to you fine nerds that may be a bigger nerd than I... I need to capture data from a nested SAP table (table name below), and cannot seem to find a command that will copy the data from SAP into anywhere. Even if this would include writing a script in SAP, if anyone is willing to work with me to figure this out, I can give you mad rep points? :-) or send you one of my bands albums for free? (www.weliketorock.com) Or maybe just sent you a virtual hug and high five?

If it helps... I know the exact size of the table, and the elements in the table, some cells filled, some empty. But even if it's a generic size, I could still work with that if I could just get the damn data out of SAP and into Excel. Also, I don't have admin rights, so I can't use many (probably helpful) transaction codes.

[dflak]

If you have at least read-only access to the SAP database, you can use MS-Query to import it. I can help you with getting MS-Query set up, and show you how to use Excel Tables and a dozen lines of VB code to alter the query "on the fly" so you can pass parameters to queries too complex for MS-Query to display graphically.

You will need the appropriate Oracle drivers on your machine.

[billyjo182]

dflak, I sent you an inbox message, if you have time check it out please.

[dflak]

Here is the instructions on ODBC if you need them.

[billyjo182]

Ok, I followed most of that, I'm attaching some pictures of the options my work computer is giving me, maybe you can guide me from here?

[billyjo182]

Ok, I followed most of that, I'm attaching some pictures of the options my work computer is giving me, maybe you can guide me from here? I'll have to upload it when I get home, work computer is not working very well right now.

[dflak]

Standing by

[dflak]

You can get Oracle Drivers here: http://www.oracle.com/technetwork/da...ft-098155.html.

You'll need to know the version of Oracle you have. Your DBA should have that answer.


Also, if you don't have a tool to run Oracle queries, WinSQL works well and there is a free version: http://web.synametrics.com/WinSQLDownload.htm. If you can get it to run in WinSQL, you can get it to run in MS-Query.