MySQL Forums
Forum List  »  MySQL for Excel

Re: read excel file with multiple sheets
Posted by: Javier Treviño
Date: March 09, 2015 04:19PM

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

Options: ReplyQuote

Written By
March 04, 2015 06:19AM
Re: read excel file with multiple sheets
March 09, 2015 04:19PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.