Link to home
Create AccountLog in
Avatar of bmarsmasker
bmarsmaskerFlag for United States of America

asked on

Eporting data from SAP 4.6C into a file or datawarehouse for Microsoft Access 2003 use.

What is the best version to download SAP into.  Lotus 123 WK has a space allotment of 2 meg.  Excel works, but there there has to be a bunch of manual manipulation to make it work.
ASKER CERTIFIED SOLUTION
Avatar of Arpit Bajpai
Arpit Bajpai
Flag of India image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Twisteddk
Twisteddk

Depending on the amount of data, I'd assume it to be rather large if you're running into a 2MB limit.
The best way to send the data would still be a CSV file usable by most applications. However, you'd need to segement the data export into more than one file if you're hitting a limit. Automatic segmentation is however not available in all SAP applications. Generally speaking manual splitting of the CSV file is the easiest way if you're only talking something done a few times. If automation is required, you may want to create a small ABAP program that will select and export the data you deisre in sufficiently small bits. However, if you choose to use ABAP, default output will be to the SERVER, not your client as the client may not (and indeed NEED not) be available during processing of the report. So you need to transfer data from the server before further processing.