When Mdb2gms.exe is executed without arguments then one receives the screen
In turn, if one specifies use of the database transport.mdb, and the query
select loca,locb,distance from dist
one addresses a data table in Access as follows
and the program generates an include file as follows
* -----------------------------------------------------
* Mdb2gms Version 1.2.1, September 2000
* Erwin Kalvelagen, GAMS Development Corp
* -----------------------------------------------------
* DAO version: 3.6
* Jet version: 4.0
* Database: c:\gams\gamspdf\bigone\transport.mdb
* Query: select loca,locb,distance from dist
* -----------------------------------------------------
seattle.new-york 2.5
seattle.chicago 1.7
seattle.topeka 1.8
san-diego.new-york 2.5
san-diego.chicago 1.8
san-diego.topeka 1.4
where in this case the data would need to be input into a parameter with beginning and trailing /'s as discussed in the Data Entry chapter.
There are a number of options in Xls2gms that merit mention
| • | Checking the quote blanks box causes the program to encapsulate strings that contains blanks in quotation marks and also deals with strings containing quotation marks. |
| • | Checking the mute box will reduce the amount of information written to the output file. The output file then becomes |
seattle.new-york 2.5
seattle.chicago 1.7
seattle.topeka 1.8
san-diego.new-york 2.5
san-diego.chicago 1.8
san-diego.topeka 1.4
| • | Checking the No listing box causes the program to enter $offlisting and $onlisting into the program suppressing the data from the LST file. |