MySQL Forums
Forum List  »  MySQL for Excel

Export appears limited to preview rows
Posted by: Kerry Marsh
Date: November 20, 2014 07:22AM

Hi - I'm new to MySQL for Excel so forgive me if I'm making a naive mistake somewhere. I'm using MySQL for Excel 1.3.3 and Workbench 6.2.

I'm trying to use it to export 35000 rows of data in my spreadsheet to MySQL. I then use MySQL Workbench to dump the .sql file of the table for my website administrator to load into our website database.

The exports appear to transact successfully - but when I check them in workbench I appear to find only either 99 or 999 rows of data in the tables. When, in MySQL for Excel, I had the number of rows for preview and calculate datatype set to 100 - I appeared to get 99 rows exported, when I set it to the maximum of 1000 I got 999 rows exported.

What am I doing wrong please ?

Kerry

Options: ReplyQuote


Subject
Views
Written By
Posted
Export appears limited to preview rows
3639
November 20, 2014 07:22AM


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.