cds — Sun, 02 Jun 2002 00:46:49 +0000

If you are using phpMyAdmin to import, save the file as a .csv file and try it with the quotes. When importing, phpMyAdmin gives you the option for fields to be optionally enclosed with quotes.

Busy — Sat, 01 Jun 2002 22:44:08 +0000

there are spaces, but no commas.
I tried the excell method, it did add quotes to everything, had to use editpad, file was to big for notepad. tried inserting a smaller version and the fields are there, just no content. I removed the spaces first btw lol, not that it would serve my needs but could help trying to figure it out, maybe it could be the '.' and '=' etc.
I might try another approach, less info, more fields

I think I have to hit the books some more, try understand this mess

Cheers

mairving — Sat, 01 Jun 2002 13:40:44 +0000

Are there spaces or commas between the fields? If not, I would try opening it in a spreadsheet like Excel. Then save the the file as a tab delimited text file. After you save the file open it in Notepad and make sure that Excel didn't add quotes " around the fields. If so, use the replace in Notepad to delete the ". Next you can import into MySQL by this statement:

<?php
load data local infile \"pathto/filename.txt\" into table tablename
(pid, pname, pdesc, phit, pcat, pdate);
?>

then do a select statement to verify data:

<?php
SELECT * from tablename backslash G
?>

For some reason the backslash won't show up here. I usually use backslash G instead of ; since it displays it in an easier to read format.