Re: [libreoffice-users] Re: LibreOffice Base and MySQL

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 <villeroy@t-online.de> 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 <staniek@kde.org>
> > 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: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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