Want to upsert data from Excel file to MySQL ?
Using XlsToMy, you can upsert data from Excel file to MySQL easily and fast, no need to program, just a few mouse clicks!
Support connect to MySQL through SSH tunnel.
Upsert data from Excel file to MySQL
Click “Wizard For Importing” at task dialog.
then show the wizard.
1. Open an Excel file.
2. Select a table and config fields.
Set “Load Type” to “Upsert”, choice “Update Key”.
3. Preview data.