Importing data in mysql?

[fvs]

I've been trying to import data from a spreadsheet into mysql database,I have it in a cvs form with the right amount of fields as my database, but each time I import into mysql I get an error message,

mysql> load data infile '/home/frank/OpenOffice_Backup/Cus.cvs' into table Custome rs;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home /frank/OpenOffice_Backup/Cus.cvs into table Customers' at line 1
mysql> load data infile '/home/frank/OpenOffice_Backup/Cus.cvs' into table Custo mers;
ERROR 13 (HY000): Can't get stat of '/home/frank/OpenOffice_Backup/Cus.cvs' (Err code: 2)
Any help appreciated. Thanks

[sdousley]

As far as i know, this is not possible. The only way i think this may be possible would be through phpMyAdmin or something like this, but i think what you're best doing is passing it through sed to create the relevent insert statements to import this to SQL

[Franklin52]

May this helps:

How do I import delimited data into MySQL?


Regards

[fvs]

Thanks for that tip, I'll try it and let you know how I made out.
Thanks for replies guys.

[sdousley]

May this helps:
How do I import delimited data into MySQL?

Fine, prove me wrong then :P

I'll make a note of that for future reference.