in reply to Re: Import file into MySQL table
in thread Import file into MySQL table

Hi,

I'm working on loading the data into a table. I'm receiving an error message that the text file cannot be located.

Here's the exact statement I'm typing in that calls in the text file.

mysql> LOAD DATA LOCAL INFILE 'C:\\Helen\\file.csv' INTO TABLE test

The rest of the command is the same as you gave me. I've read through the MySQL book on how to read a local file and I'm not sure what's happening.

Any ideas? Thanks.