MDB2GDX1.gms : Creates a GDX File using MDB2GMS at execution Time and displays it in GDXVIEWER

Description

Store data from Access database (file Transportation.mdb) into a GDX file.
Note that the results are queried using MDB2GMS within the model MDBsr0.
The results are written to include files at first. Afterwards, they are
included to the model and the data is finally stored in Transportation.gdx
using the command-line argument 'gdx='.
The GDX file is displayed using the 'gdxviewer' tool.

This model is referenced in section "Strategies" from the MDB2GMS Documentation.

Keywords: MDB2GMS, data exchange, GAMS language features


Category : GAMS Data Utilities library


Main file : MDB2GDX1.gms   includes :  MDBSr0.gms  Transportation.mdb  MDB2GDX1.gms

$title Creates a GDX File using MDB2GMS at execution Time and displays it in GDXVIEWER (MDB2GDX1,SEQ=042)

$onText
Store data from Access database (file Transportation.mdb) into a GDX file.
Note that the results are queried using MDB2GMS within the model MDBsr0.
The results are written to include files at first. Afterwards, they are
included to the model and the data is finally stored in Transportation.gdx
using the command-line argument 'gdx='.
The GDX file is displayed using the 'gdxviewer' tool.

This model is referenced in section "Strategies" from the MDB2GMS Documentation.

Keywords: MDB2GMS, data exchange, GAMS language features
$offText

$if %system.filesys% == UNIX $abort.noError 'This model cannot run on a non-Windows platform';
$call msappavail -Access
$ifE errorlevel<>0 $abort.noError 'Microsoft Access is not available!';

execute '=gams.exe MDBsr0 lo=%GAMS.lo% gdx=Transportation.gdx';
abort$errorLevel "step 0 failed";
execute '=gdxviewer.exe Transportation.gdx';