Hi Ian, I frequently import Calc Spreadsheets into my MySQL database using phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to import.Specifically, it offers a Browse option. Locate the Calc file you wish to import.by browsing to it in your file system. It also asks for the type of file you wish to import. One of the options is ODF spreadsheet.That's the format of Calc, isn't it ? No need to convert to CSV File. Hank
On Thu, Jan 21, 2016 at 7:43 AM, Andreas Säger <[email protected]> wrote: > Am 21.01.2016 um 13:20 schrieb Heinrich Stoellinger: > > Of course these are valid values as for as CSV is concerned, but not ALL > > are > > valid as far as MySQL goes. I have no problem restoring MySQL-DATE COLUMN > > values, but represent them as "2014-12-22", the same as character > strings. > > Forget Base at the moment and deal with the stipulations of SQL, in > > particular > > MySQL. > > > > On Thu, 21 Jan 2016 11:37:51 +0100, Jaroslaw Staniek <[email protected]> > > wrote: > > > > Of course, ISO dates are the one and only unambiguous standard for date > strings. It is not too difficult to convert other date strings with 3 > numbers and 2 separators into ISO strings which can be converted to real > date values. > > > -- > To unsubscribe e-mail to: [email protected] > 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 > -- To unsubscribe e-mail to: [email protected] 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
