Page 1 of 1

Accessing Adabas from Microsoft Excel

PostPosted: May 10th, 2011, 8:59 pm
by WolfgangWinter
With Portus importing data into MS Excel, MS Word etc. is a breeze, with absolutely NO client footprint,
no programming (except for an Excel macro, in case you want to create management reports or the like), you will get XML
right from the server to the target application.

    - Start Excel, create an empty worksheet
    - Data -> import external data -> new web query
    - Enter the request URI into the 'address' field, then click 'Start. When you do not have a service readily available on your own Portus server please feel free to use: http://asg-demo:56421/adabas_Employees? ... l_id=5000*
    - Click 'import'
    - at that stage you might be asked if you want to create a schema from the data, answer 'yes' (and probably 'remember' the answer)
    - Just click 'OK' on the following dialog which asks where to import the data to

! DONE !