For exporting XML data from a Swift Document to Microsoft Access (MDB or ACCDB) format, use the exportMDB action as follows: This command exports all tables and queries in the Swift Document ‘Data.xdb’ to an Access database ‘Data.mdb’.
|
You can specify specific tables and/or queries to export by listing them out on the command line.
|
Please note that if a query has the same name as an existing table, the query will be exported. To have the table of the same name to be exported instead, please prepend the table name with a ^ as follows:
|
By default, existing output files will not be overwritten. To overwrite the output file (‘Data.mdb’), use the -w option:
|
The Access database created is compatible with Access 2003. You can specify a different version of access using the ‘-a <Version>’ as follows:
|
Valid values for ‘Version’ are:
2007: For Microsoft Access 2007.
2003: For Microsoft Access 2003.
97: For Microsoft Access 97.
Create Pivot Tables and Pivot Charts from Large Datasets.
Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.
Import XML data into automatically created MySQL tables.