Hi Ian and all:
Excuse me if I understood bad your problem.
I understood that you need import a .CSV file to BASE with BASE. And
You can't do it.
I suggest to you to open the .CSV file with CALC. Then save it as .ODS.
Finally, import from BASE the .ODS file.
I hope this help.
Regards,
Jorge Rodríguez
El mié, 16-03-2016 a las 22:19 +0200, Ian "Witty" Whitfield escribió:
> Thanks all - appreciated!!
>
> My background is 30 years in the Computer Business - Training,
> installations, support etc etc.
> Since retiring I left Windows behind and changed to Linux.
> What I'm not is a Programmer - except with BASIC about 20 years ago!!!
>
> My needs are to have a SOLID, RELIABLE simple Members Database that does
> not crash all the time and take the data with it as well.
> I don't even need a RDB as I have one table, one Form and a few queries,
> it is single user on a single machine. My Form only uses Text Boxes,
> Drop-Down Boxes, Check Boxes and Photos and Graphics. End of story!! i
> don't want to become a DB expert just a basic layout person and every
> day user.
>
> I did not think this would be a big problem in Linux - how wrong I was.
> I have battled with Base for several years and after my last crash in
> January, (Data lost, as is common, even with MySQL. The file is still
> there but it can not be accessed).
>
> I thank Jarasow for his help with Kexi but after 10 crashes in 2 weeks
> and some missing features and no help to try and get Drop-boxes to work
> I had to give up on it. It does look very promising but has a way to go
> yet I fear.
>
> So Alexander has told me how to save my Form (that helps a lot) and I
> decided to get back into Base as it seems to be the only way to go for
> me. But MySQL is giving me up-hill. It does not seem to want to save an
> empty Table for me to import my CSV into and gives me this error ...
>
> "#1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'varchar(10), `NULL` varchar(10), `NULL` varchar(10), `NULL`
> varchar(21), `NULL` ' at line 1"
>
> I seem to remember this from when I first set it up last year. It's not
> MY SQL - this is what the program did!! Also my first line of the CSV is
> the column names only and it works OK with Calc and did so as well with
> Kexi!! So where is the problem??!!
> So I'm unable to populate the DB in MySQL for Base to link to it!!
>
> Thanks all.
>
--
Atentamente,
Jorge Rodríguez
--
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
