Hi Ian,
If you are importing a spreadsheet into your MySql Database, you should be
able to do this without using Base.
Alexander feels it may be that we are using different versions of
phpMyAdmin. He may be right..
Two years ago I imported my Base database tables to a MySQL Database
running on a re
Am 24.01.2016 um 09:04 schrieb Hank Alper:
> 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 browsi
Le 24/01/2016 09:04, Hank Alper a écrit :
Hi Hank,
> 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 impor
On 26 January 2016 at 12:42, Ian "Witty" Whitfield wrote:
> On 01/24/2016 10:04 AM, Hank Alper wrote:
>
>> 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
On 01/24/2016 10:04 AM, Hank Alper wrote:
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
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 ty
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 Bas
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 part
On 20 January 2016 at 21:34, Andreas Säger wrote:
> How can anybody solve any csv related problem without knowing anything
> about
> the actual content?
>
> 4 different lines of perfectly valid and commonly used csv data:
>
> 1234.98;2014-12-22
> 1.234,98;22 Dez 2014
> 1234.98;12/22/14
> 1234.98;
How can anybody solve any csv related problem without knowing anything about
the actual content?
4 different lines of perfectly valid and commonly used csv data:
1234.98;2014-12-22
1.234,98;22 Dez 2014
1234.98;12/22/14
1234.98;22/12/14
Each line carries the exact same information. I could add a
When using HSQL (which is less powerful than MySQL) command CREATE TEXT
TABLE "Foo"(...) prepares a table "Foo" with fields and indices just
like a regular data table. A second command SET TABLE "Foo"... links the
text table "Foo" to a particular text file.
If the linked text table and the underlyi
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 actu
Am 20.01.2016 um 11:05 schrieb Ian Whitfield:
> Hi All
>
> I have been trying to import a CSV file from Calc into MySQL to run with
> Base for over a week now and can not believe this is so difficult to do
> so I'm hoping some other Base users might have cracked this one!!
>
> My OpSys is PClinux
13 matches
Mail list logo