The SAP Fan Club Forums

by **chdh** » Fri Sep 05, 2003 5:06 am

What is the best way for end users (non-programmers) to export data from SAP ad-hoc queries into MS-Access or SQL-Server tables?

Christian

by **Kiowa54** » Mon Dec 22, 2003 6:37 pm

We have been exporting out of SAP R3 using the "Spreadsheet" or "Excel in place" function in the Toolbars.

You should have this at a minimum.

We have been using linked spreadsheets in Access to create reports and Queries.

If you build the Access db to conform to your data extracts you can either cut and past to append the spreadsheets or import the data into Access as tables (remember this could overwrite any existing data in your existing table).

Hope this helps. We have only been at R3 for 90 days.

by **chdh** » Mon Jan 05, 2004 3:26 pm

Thanks for your answer.

by **vikcha** » Thu Feb 19, 2004 4:06 pm

Try the TablePro product from WinShuttle.
http://www.winshuttle.com

by **Iggy** » Wed Feb 25, 2004 10:03 am

Hi,

StreamServe can support a SAP/MSExcel or SAP/Access interface quite easily.

Regards,

Iggy

by **Guest** » Thu Jun 10, 2004 3:33 pm

You can try Tables Explorer from Mps.

http://www.mpshp.com/tablesexplorer.swf.html

The SAP Fan Club Forums

Export data from ad-hoc queries to MS-Access?

Export data from ad-hoc queries to MS-Access?

Export to Access

Export data from ad-hoc queries to MS-Access?

Ad-Hoc Queries to Access

Who is online