This website is not affiliated with, sponsored by, or approved by SAP AG.

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

Third Party products such as GuiXT, BMC Patrol, Vertex, Ixos etc...

Moderators: Snowy, thx4allthefish

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

Postby chdh on 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

chdh
 
Posts: 2
Joined: Fri Sep 05, 2003 5:02 am
Location: Switzerland

Export to Access

Postby Kiowa54 on 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.
Kiowa54
 

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

Postby chdh on Mon Jan 05, 2004 3:26 pm

Thanks for your answer.
chdh
 
Posts: 2
Joined: Fri Sep 05, 2003 5:02 am
Location: Switzerland

Postby vikcha on Thu Feb 19, 2004 4:06 pm

Try the TablePro product from WinShuttle.
http://www.winshuttle.com
vikcha
 
Posts: 7
Joined: Wed Feb 11, 2004 3:29 pm

Ad-Hoc Queries to Access

Postby Iggy on Wed Feb 25, 2004 10:03 am

Hi,

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

Regards,

Iggy
Iggy
 

Postby Guest on Thu Jun 10, 2004 3:33 pm

You can try Tables Explorer from Mps.

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


Return to Third Party Products

Who is online

Users browsing this forum: No registered users and 2 guests



This website is not affiliated with, sponsored by, or approved by SAP AG.