Re: read excel file with multiple sheets

[Javier Treviño]

Hi John,
Thanks for writing in our forums!

It all depends, if you need to do what you describe as an automated process I would suggest you write a specific application using your favorite programming language and a MySQL Connector related to that language, to perform the task.

If you want to do this manually you could use MySQL for Excel and see if it works for you.

You are not specifying how you want to handle scenarios where the data in the Excel sheets already exist in the MySQL tables (i.e. duplicate primary or unique keys, for instance). So if you need something very specific then you should consider writing your own app.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team