Re: Export from Excel 2010 to MySQL error: Table was not exported due to rows insertion
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