load data csv files

[rakennedy75]

I use phpMyAdmin to import tab delimited files using this command ...

load data infile 'my/text/file/path.txt' into table myTable;

This works but will this work with a csv or comma delimted file. If not is there a specific command that would do the same.

Thanks for your help and time.

[bastien]

yes, in the screen where you choose the file, there is a field for defining how the items are separated

[rakennedy75]

The screen i pull up doesn't give any options. Are you thinking of the export features.

I guess what my real question is about the (MySQL) command "LOAD DATA INFILE ....", will this work with csv files as well as tab delimited. So if I was write this command straight into MySQL than would it work with csv or comma delimited. If not what command would or how could I add csv files.

thaks for your time

[sneakyimp]

i'm working on this same problem. this thread looks helpful:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10261206&highlight=comma+delimited