Skip to Content
avatar image
Former Member

Upload SAP Table data to MS-ACCESS table?

We have a requirement that " Upload a table data from SAP to MS-ACCESS Database Table directly".

I created a table with 2 fields in SAP with data and then Upload that data to MS ACCESS table regularly.

Means, direct connectivity to SAP Database to MS-ACESS Database

How to do it? What are the techniques available? are any database or program configurations required?

Please help me out.

thanks in advance.

Regards

Sarayu.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 07, 2009 at 07:31 AM

    SAP always has a underlying database to which it is connected. like oracle, db2, ms-access etc.

    talk to the basis guys to solve your issue.

    SAP Database what you see in the GUI is just a layer where you see the formatted under lying data,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 07, 2009 at 08:47 AM

    Hi,

    use the standard ABAP program "RIACCESS".

    Before using the program "RIACCESS", you need to install the PS utilities, which are part of SAPGUI install CD.

    It is available in the "\SAPGUI\PS directory".

    Then do the followings :

    1. Select transaction code SALE -> Systems in network-> Define RFC Destination.

    2. You will need two RFC destinations (TCP/IP connections for the front-end workstation).

    Setup the two RFC destinations PS_ACCESS_1 and PS_ACCESS_2 and you'll have to get them to point to

    wdpsastr.exe and wdpsatab.exe respectively.

    3. Then execute RIACCESS and choose PS_ACCESS_1 to generate access tables.

    The system must also be able to access the RFC-DLL files (librfc2.dll, librfc3.dll, librfc4.dll, librfc5.dll, librfc6.dll, vrfc.dll).

    Please note that Access only supports tables with up to 255 fields

    or

    u can check this link,

    Unable to Download SAP TABLE DATA to MS ACCESS

    u get a lot of similiar thread.

    regards,

    Archana

    Edited by: Archana Kumari on Aug 7, 2009 10:48 AM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 31, 2009 at 08:56 AM

    self answered

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 23, 2013 at 07:18 AM

    Dear Sarayu,

         I had same requirement,please suggest how to solve your issue.

    Add comment
    10|10000 characters needed characters exceeded