MySQL Forums
Forum List  »  MySQL for Excel

Re: How to upload data from Excel to Mysql automatic?
Posted by: Javier Treviño
Date: October 09, 2013 10:19AM

Hi Li,
Thanks for writing in our forums.
Judging by the example you provide I guess that you are talking about exporting denormalized data stored in a single Excel worksheet and map it into normalized MySQL tables somehow "automatically".

Using MySQL for Excel you can leverage some of that work by playing with the data in Excel and exporting the data you want to specific MySQL tables, but you would need to do this table by table.

If you need this to be somehow "automatic" for a specific Excel workbook you would need to develop a custom solution for your needs, you need to consider a way to map columns to different tables and somehow define/detect relationships automatically, and you can write this in different programming languages.

Best Regards.

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to upload data from Excel to Mysql automatic?
1366
October 09, 2013 10:19AM


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.