Import datas from excel to Mysql

[Romain]

Hello,

I really need your help about the following topic.
I have a database with one table with about 5000 entries and I would
like to import them to my MySQL database which is made with 10 tables.
I am getting worried about the feasibility of the importation. I give
you a simplified example below:

*** Excel Database ****

Firm / Job / Family Name / First Name / Adress / Zip Code /

*** MySQL Database ****

- tblFirm
IdFirm / strName /

- tblJob
IdFirm / IdPerson / strJob /

-tblPerson
IdPerson / Family Name / First Name / Adress / Zip Code /

So as you see the problem is in filling the tables tblFirm and tblJob.
Using the import function of MySQL I may be able to import the datas
for tblPerson easily but I don't see how to fill in tblFirm and
tblJob. Is anyone can help me with this? do you think XML can help me
with this.
Thank You very much !!

[ma...@monitor.wc.lt]

Use http://excel2sql.esy.es/ Excel to SQL online converter- Generates SQL insert script from xlsx , xls , csv files to easy import in MySQL database or MS SQL server.Hope it helps !