Automate

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
------------------------------

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
------------------------------