Hmm...that seems like a bug...if those commas are inside quotes, they should
not be interpreted as field delimiters. You might want to check if there are
any stray quotes elsewhere on the line that are messing up the
interpretation. If not, then I would think that to be a bug.
j- k-
inal-
> De: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
> Enviado el: Miércoles, 07 de Julio de 2004 05:37 p.m.
> Para: [EMAIL PROTECTED]
> Asunto: Re: DBF to MySQL
>
> I'm sure it did...DBF and XLS files are not plain text. What Chincilla gave
> your was a bit of code
I'm sure it did...DBF and XLS files are not plain text. What Chincilla gave
your was a bit of code for importing CSV files, after they had been exported
from Excel. I'm not sure *why* he gave you that code.
You can do one of two things. 1) Open up those files in Excel (it will also
open DBF
At 20:55 -0700 7/6/04, John Mistler wrote:
For some reason, the imported information showed up as garbled nonsense.
The file I was importing was an .xls file. Do you know if there is another
"TERMINATED BY" I should be using? If not, I wonder how I can find out?
LOAD DATA will not, I think, read
John:
I´m new to MySQL but I hope this could help.
Please read below.
Regards from Costa Rica
-Mensaje original-
De: John Mistler [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 06 de Julio de 2004 09:55 p.m.
Para: [EMAIL PROTECTED]
Asunto: Re: DBF to MySQL
For some reason, the imported
For some reason, the imported information showed up as garbled nonsense.
The file I was importing was an .xls file. Do you know if there is another
"TERMINATED BY" I should be using? If not, I wonder how I can find out?
The other question I have is: do I have to create a table within the MySQL
Try, for example:
LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';
-Mensaje original-
De: John Mistler [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 06 de Julio de 2004 04:51 p.m.
Para: [EMAIL PROTECTED]
Asunto: DBF to M
El Martes 21 Agosto 2001 15:23, escribiste:
> Hello,
>
> I have downloaded your dbf2mysql-1.14.tar file from the
> MySQL.com site. I read through the README and still
> cannot seem to get this to work. Here is the error I'm
> getting:
>
> [info:admin/Desktop/dbf2mysql-1.14] root# make
> /usr/bin/