topic Re: Export Data to MS-Access Database in Application Development and Automation Discussions

Export Data to MS-Access Database

Former Member — Mon, 03 May 2010 15:44:02 GMT

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

Re: Export Data to MS-Access Database

Sandra_Rossi — Mon, 03 May 2010 22:10:08 GMT

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.

Re: Export Data to MS-Access Database

Former Member — Tue, 04 May 2010 09:22:37 GMT

 (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