Export Data to MS-Access Database

[Former Member]

Hello,

i want to export some data to a MS Access Database.

I use a SAP R/3 System!

I imagine it like this:

1. Every week is running a batch job, who exports the data to an external file.

(How can i choose the data which should be send to the external file?? I need the ABAP programming???)

2. Then i import the external file into the Access Database...

Is this the right way?

I hope you can help me...

thanks:-)))

Edited by: Rosicky1001 on May 3, 2010 5:47 PM

[Sandra_Rossi]

When you run ABAP programs in background, that is practically impossible to store data directly in an Office application because of the coded format of the files (in dialog, we may use OLE2 to communicate). So, the ABAP program could write one or more CSV files then you import them as you want into Access. You say that you want ABAP code, but your question is really too vague. Search forum and sap library for OPEN DATASET, TRANSFER and CLOSE DATASET, which are used to read or write files.

[Former Member]

 (How can i choose the data which should be send to the external file?? I need the ABAP programming???) 

You have multiple options if you need to Export SAP data, depending on the selection logic complexity you can go either of below method

1) ABAP Program

2) SAP Ad Hoc Queries (SQ01, 02, 03)

3) ALE IDOCs with File port if your messaget type is exactly the way you want in MS Excel