How to upload data from Excel to Mysql automatic?

[Li XU]

Good morning everyone,

I am thingking about a method to upload data from excel to mysql automatic.
The data in excel match more than just one table in mysql.

For exemple, in excel we have 'firstname', 'lastnama', 'IBM'.
In mysql, 'firstname' and 'lastname' matchs the table "person", however, 'IBM' match the table "company".

So what I want is: I give you a file excel with data 'firstname','lastnama','IBM'.
and we have to upload these automatic in mysql,also link the table "person" and "company" by setting the "foreign key". All of this process have to be automated.

Up to now, I only know we can write a script to realize it. But is there anyone who did this before? Or do you have any other propose?

Thank you very much for your attention.

Best wishes,
Li