Skip to Content
avatar image
Former Member

Doanload data in MS Access

Hi

Does anyone know how i can download data from SAP R3 into MS Access. eg: If i want to get data from a table in SAP - VBAK, will it be possible to get that data downloaded in MS Access,

Regards

Avi

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 05, 2007 at 01:51 PM

    Hi

    The following options are available to down data for table VBAK

    EDIT->Download->

    *Unconverted

    *Spreadsheet

    *Rich text format

    *HTML Format

    *Copy to Clipboard

    Regards

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2007 at 01:52 PM

    Hi

    You can download the VBAK table contents to MS-Excel from there you can copy to MS-Access.

    Reward if it helps

    Chandra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 05, 2007 at 02:00 PM

    Thanks

    I am aware of this however the data is much bigger than excel can contain so would prefer to directly download it to MS ACCESS. The plan is to actually try and get a live feed so it is updated all the time.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2007 at 01:58 AM

    Hi,

    I am also trying to download to MS Access. You need to install some files downloaded from SAP. After setting up you can download the structure and download the table. I saw some information here:-

    http://sap.ittoolbox.com/groups/technical-functional/sap-dev/download-into-msaccess-168725

    However, for your information, I myself have only succeeded in downloading the structure of the table. When I tried to download the data, I encountered with error. But some persons said it is successful. Please update if you are successful.

    rgds,

    Add comment
    10|10000 characters needed characters exceeded