How to Export SAP R/3 data to Microsoft Access
As you have seen, exporting SAP data to Microsoft Excel and Word is useful when it comes to performing further offline manipulation of your data, for creating reports and graphs, or for drafting form letters. Exporting data to a Microsoft Access database is quite useful, too, when it comes to general reporting.
The initial steps to export data into Microsoft Access are the same as the steps to download a file into Microsoft Excelthe idea is to get the data into the Excel XLS format. Verify this is the case before proceeding.
Watch Out!
Depending on your Microsoft Excel configuration, you might have to perform a few extra steps here:
1. Launch Microsoft Excel and open the spreadsheet you saved earlier.
2. In Excel, use the menu path File, Save Asas if you were going to save the file again.
3. Take a close look at the Save As Type box; ensure that the file is saved as a Microsoft Excel Worksheet and not any other format.
By the Way
Exporting to Microsoft Access is helpful as well when you want to compare data among multiple systems. For example, if your company stores your vendor master data in SAP and it also stores vendor master data in a non-SAP application (and you have not implemented SAP Exchange Infrastructure with Master Data Management), you can use Microsoft Access as a tool to quickly compare the two sources relative to overall data consistency.
Popularity: 15% [?]
