Below an example of an export to a Microsoft access database is set up. The LoadExport protocol should have the Export format ADO and the Local export file pionted to is the settingsfile for the SQL-export.
Exportname load (as well as temp, wind and glob) can be used as variable %ID% in the SQL definition file. This means that one export for each checked parameter is made. The only limitation is that the same SQL statement will be used; the only difference will be the value of the %ID% variable (and the data of course)
“Local exportfile” is the name of the XML file with the SQL question. The settingsfile is opened by clicking the edit button to the right.
In the settingsfile a Source path is pointed out. The path is set as an absolute path on the server and the file must be created before the export is run. In this example setup the export will write to the same access database file every time.
For a deeper understanding of the example file see the previous chapter “SQL Export configuration file elements”.
Tip! Make sure the access database driver is installed on the computer where the export is run.