Re: DBF to MySQL

2004-07-08 Thread Joshua J. Kugler
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-

Re: DBF to MySQL

2004-07-08 Thread John Mistler
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

Re: DBF to MySQL

2004-07-07 Thread Joshua J. Kugler
gt; > > > > > -----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 MySQL > > > > I am wanting to parse the info in a .dbf file

Re: DBF to MySQL

2004-07-07 Thread Paul DuBois
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 MySQL I am wanting to parse

RE: DBF to MySQL

2004-07-07 Thread "Chinchilla Zúñiga, Guillermo"
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

Re: DBF to MySQL

2004-07-06 Thread John Mistler
Mistler [mailto:[EMAIL PROTECTED] > Enviado el: Martes, 06 de Julio de 2004 04:51 p.m. > Para: [EMAIL PROTECTED] > Asunto: DBF to MySQL > > I am wanting to parse the info in a .dbf file (or .xls file for that matter) > and place it in a table in a MySQL database. Is this something

RE: DBF to MySQL

2004-07-06 Thread "Chinchilla Zúñiga, Guillermo"
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:5

DBF to MySQL

2004-07-06 Thread John Mistler
I am wanting to parse the info in a .dbf file (or .xls file for that matter) and place it in a table in a MySQL database. Is this something that I can do with the server side MySQL application, or do I need to figure out a way to do it on the client side? Any description of the method would be ve

DBF to MySQL Problem?

2001-08-21 Thread Nathan Walker
21 Aug 2001 16:23:56 -0500 To: <[EMAIL PROTECTED]> Subject: DBF to MySQL Problem? 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/dbf

Re: DBF to MySQL Problem?

2001-08-21 Thread Alfredo Cole
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/

DBF to MySQL Problem?

2001-08-21 Thread Nathan Walker
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/cc -O2 -Wall -DVERSION=\"1.14\" -I/usr/local/ mysql -c -o db