FileToDB

FileToDB: A functional solution for importing Excel spreadsheet data into MySQL databases

XlsToMy is an efficient piece of software that enables you to import Excel spreadsheet data into MySQL databases in new tables or exiting ones.

You will need to log into a database to access the application’s interface. It is possible to choose between MySQL or SSH connections. To connect to your MySQL database you will need to fill in your username, password, port and host address.

Once the connection has been established you can import an Excel file and select the sheet and rows you want to import into your MySQL database.

XlsToMy can be used to generate a batch file which can be executed in Command Line, as well as to create scheduled tasks.