Automate

 View Only

  • 1.  How to direct query result to a Microsoft Access database

    Posted 05-19-2022 08:06
    I am getting back into using Winshuttle after being away from it for a few years and I am trying to create an Access database that receives data from query results, manipulates those queries using data from an Adobe form, and then loads it back into SAP via Transaction.  Can someone give me some guidance or direction as to how to download my query results directly into an Access database.

    ------------------------------
    Mark Watson | Sr. SAP Data Analyst
    TCCC - CCNA - HCM | 513-302-9343
    ------------------------------


  • 2.  RE: How to direct query result to a Microsoft Access database

    Employee
    Posted 05-20-2022 19:16
    Hi Mark

    There's some high level documentation here:  https://docs.winshuttle.com/studio-en-20-2-online-help-studio-with-connect/map-query-fields-access.htm?tocpath=Studio%2020.2%20Online%20Help%7CQuery%7CMap%20Fields%7C_____3

    In the mapping tab choose Access

    It defaults to Table1, but you can rename it by right clicking on it.

    then click add column

    choose your output field and optionally enter a different field name for the Access table column name, like


    When you save or click to run it, it will prompt for a file name for your access db (instead of an Excel file)




    You then have your query matched up to an Access DB.

    Hope that helps,
    Sigrid






    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------

    Original Message