Home > XlsToMy, Excel to Mysql > Execute command line and schedualed

XlsToMy - Mysql import Excel »

How to execute command line and schedualed

We can run from command line or create a batch file(replace the "username", "password", "server", "database" and "port" with your own database user info. The lines wrap in this page, but in the file is 1 line):

	"C:\Program files\XlsToMy\XlsToMy" 
	username=root password=123456 server=192.168.1.5 database=test port=3306 
	session=E:\testcase\employees.xlf
	logfile=E:\testcase\employees.log

Import data from Excel to Mysql - command line

or use "workspace" (contains multiple sessions), the workitems(sessions) can be queued. 
	"C:\Program files\XlsToMy\XlsToMy" 
	username=root password=123456 server=192.168.1.5 database=test port=3306 
	workspace=E:\testcase\import_all.xtw
	logfile=E:\testcase\import_all.log

Excel to Mysql - command line batch

The XlsToMy parameter descriptions are as follows: 

	username: Your Mysql system username.

	password: Your Mysql system password.

	server: Your Mysql hostname or ip address.

	database: Your Mysql database name, such as "test".

	port: default is 3306.

	unicode: If you want to import unicode data, set "unicode=true",  default is false.

	session: The session file name, to create a seesion file, please see this page: Save/Load session.

	logfile: The log file name.

You may need to run a batch file at a specific time and/or at a certain time every day. Below is additional information about how to do this.

Microsoft Windows 98, ME, 2000, and XP users

With the introduction of Microsoft Windows 98, Microsoft has included Scheduled Tasks, a software program designed to run any program, including batch files, at any time or any schedule you desire. To run Scheduled Tasks, follow the below steps.

  1. Click Start
  2. Click Programs
  3. Click Accessories, System Tools, and then Scheduled Tasks.

Once open, you'll be able to create your own custom task by clicking Add Scheduled Task, which will start you through the wizard, prompting you with what program you wish to execute, how often you wish to run it (daily, weekly, monthly, one time only, when my computer starts, and when I log on), the time you wish to run, and how often each day to run.

XlsToMy is a data conversion tool that helps DBA and database programmer import Excel data to Mysql database.

30-day free trial Download XlsToMy US$59.95 Buy XlsToMy