Command line usage MDB to XLS Converter
This topic describes how to use MDB to XLS Converter
command line parametersYou can use them to specify actions, which must be performed by the program at launch.
Command line parameters allows you to launch MDB to XLS Converter from your own applications, command files, and so on.
Using command line can save you a lot of time, you can automatize everyday tasks and run them with a single click or by scheduler.
The basic syntax is:
mdb2xls.exe c:\tmp\source.mdb -output=c:\tmp\ -batch [other parameters]
mdb2xls.exe c:\tmp\source.accdb -output=c:\tmp\ -silent [other parameters]
Source file, Output file or folder, and -batch or -silent parameters are mandatory.
-batch runs the app and displays a main window
-silent runs the app and does not display any windows.
We recommend to use -batch during tuning and testing and then replace it to -silent
The long command line does not look pretty.
Therefore the good solution is to put command line parameters to another file - one parameter per line and run converter as:
mdb2xls.exe @c:\tmp\params.ini
c:\tmp\source.mdb
-output=c:\tmp\
-files=overwrite
-type=xlsx
-batch
You can combine parameters in the file and in the command line.
You can use comments, just add ; in the beginning of a line
mdb2xls.exe c:\tmp\source.accdb @c:\tmp\params.ini
-output=c:\tmp\
-separate=1
;overwrite existing files
-files=overwrite
-type=xls
-silent
It is hard to remember all parameters, so we created a really great helper for you: Expert mode!
Just launch MDB to XLS Converter, select source file(s), the output file/folder,
select necessary parameters, such as a field delimiter, code page, quotes etc.
Then click the button "Expert mode" and you will see how all your settings become command line parameters!
Moreover, this dialog allows you to save them as command .bat file, and a shortcut, and as .ini
If you did everything correct, you can run the converter by clicking on .bat or shortcut.