Using other data sources

The initializations block can work with many different data sources and formats thanks to the notion of I/O drivers.

I/O drivers for physical data files:

• mmodbc.odbc for databases with ODBC connector
• mmsheet.excel for MS Excel spreadsheets
• mmsheet.xls and mmsheet.xlsx for generic spreadsheet access, including on non-Windows platforms
• mmsheet.csv for CSV format files
• mmoci.oci for Oracle databases
• mmetc.diskdata for mp-model style data files

Other drivers are available, e.g. for data exchange in memory between models or between a model and the host application.

Change of the data source = change of the I/O driver, no other modifications to your model

initializations from "mmsheet.xls:mydat.xls"
 COST as 'CostData'
end-initializations

initializations to "mmodbc.odbc:mydat.mdb"
 SOL as 'SolTable'
end-initializations