Le 20/01/2016 11:05, Ian Whitfield a écrit :

Ian,

I would suggest opening up your Calc created CSV in a normal text
editor, to see what it "really" looks like. Only in this way will you be
able to choose the right options to import the data into mysql.

As Andreas has rightly said, you don't actually need a graphical tool to
import CSV files into mysql - the official mysql technical
documentation, if you care to read it, is really quite good in this
respect :

http://dev.mysql.com/doc/refman/5.7/en/load-data.html

Also, this tutorial gives some very handy examples of how to import CSV
files into mysql :

http://www.mysqltutorial.org/import-csv-file-mysql-table/


The error messages you are seeing seem to indicate that the data you are
trying to input doesn't correspond to the definition of that data which
is set in the database.


Alex


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to