MySQL Forums
Forum List  »  MySQL for Excel

Re: Export from Excel 2010 to MySQL error: Table was not exported due to rows insertion
Posted by: Javier Treviño
Date: July 21, 2014 08:53AM

Hi Brian,
Thanks for writing in our forums!
In the same dialog you are getting that error there should be a "Show Details" button at the lower left part of the dialog window. If you click it you should see the reason for the table creation error, since the error is upon the table creation the 10K rows you are trying to export are not the cause of the error, but maybe the names or the data types being declared for each column.

The Export Data dialog will give you indications if any error is likely to occur before you attempt the data export. If it detects the data type you select is not suitable for the subset of data being previewed, a warning icon will be displayed and the column in the preview data grid will turn red. Same happens if you give the table or any of its columns a name that could most likely cause an error.

I strongly recommend you reading this blog post first:
https://blogs.oracle.com/MySqlOnWindows/entry/how_to_guide_to_exporting

If you still feel there is nothing wrong with the table or column properties you see in the Export Data dialog, then I suggest you to change the setting of how SQL queries are shown to "Preview SQL queries before they are sent to the server". You can refer to this blog post for details:
https://blogs.oracle.com/MySqlOnWindows/entry/sql_queries_preview_before_sent

That way you can check if the generated SQL query for the table creation looks OK. If you do not know how to check it, you can copy&paste in a reply on this thread.

Let us know your findings.

Best Regards.

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Export from Excel 2010 to MySQL error: Table was not exported due to rows insertion
2953
July 21, 2014 08:53AM


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.