Excel2MySQL

Command Line Interface Examples

If you need to automate or schedule Excel to MySQL conversions, you can take advantage of the special batch/shell version of Excel2MySQL which is called excel2mysqlCLI. This can eliminate the need for any "updating" cronjobs on servers.

Simply setup a bat file which calls excel2mysqlCLI.exe for each file to be loaded.
Of course, you'll need to substitute your own values for myhost, mydb, myuser, mypass.. etc.

Supports all Excel versions and doesn't require Microsoft Office install. You can import any of the following extensions (.xls, .xlsx, ..xlsm, xlw, .xla, .xlsb, .xlt).

Example 1: Import an Excel file to a remote MySQL server.

excel2mysqlCLI.exe -f "data1.xlsx" -z myhost -d mydb -u myid -p mypass --append

Example 2: Import 3 Excel files with the following commands in a bat file:

excel2mysqlCLI.exe -f "data1.xlsx" -d mydb -u myuserid -p mypass --append
excel2mysqlCLI.exe -f "data2.xlsx" -d mydb -u myuserid -p mypass --append
excel2mysqlCLI.exe -f "data3.xlsx" -d mydb -u myuserid -p mypass --append

Example 3: If you have hundreds of files, you could use a loop in your bat file like this:

for %%f in (*.xlsx) do excel2mysqlCLI.exe -f "%%f" -d mydb
-u myuserid -p mypass --append

* Please refer to the Command-Line Options below for all available options.

You can then simply run your bat file as needed OR use "windows task scheduler" to schedule the bat file for running daily/hourly... etc.

You can also call the command-line version of Excel2MySQL with your favorite programming language, such as Python, Perl, C++, etc... However , a bat file is the simplest option for most users.

I would be happy to help you get your bat file configured.
Let me know if you need my help.

Command-Line Options

Parameters

Note: Parameter values that contain spaces should be enclosed in quotes (for example: -d "my database")

Switches