How to load SAP-data with Xtract Universal to Microsoft Access (and Excel)

Xtract Universal is since 2011 the newest member of the Xtract product line. Eight different SAP extraction types allow the BI architect to create an optimal, stable and fast data layer between SAP and different consumer applications.

Xtract Universal essentially consists of two components: a server component and a designer (client). The server component is responsible for the actual extraction. The consumer application communicates with the Server component, and these in turn with SAP. You use the Xtract designer for the design and configuration of the extractions.

Fore more information refer to the products page: http://www.theobald-software.com/en/products.htm
or to the help page: http://help.theobald-software.com

In this blog, I will show you how to load SAP-data with Xtract Universal to Microsoft Access.


Step 1: Create an Extraction. Go to General Settings and set Output to XML:

Step 2: Click on Run and copy the URL:

Step 3: In Access click on XML File and follow those steps:


Step 4: Paste the URL in the field File Name. Click on OK.


Step 5: Select the Table. Click on OK.

Step 6: Click on Close.

Step 7: Now you have the SAP-data in an Access Table.


You can also load the SAP-data alternatively to Excel via "Data -> From Other Sources -> From XML Data Import".
To load SAP-data directly to PowerPivot refer to our Product Xtract PPV.