CSV file to MySQL ??

grantrobarts

I have a CSV that I want to convert into a mySQL table.

Here's the CSV:
http://server.e3-aion.com/~granto/ACDB.csv

I want to either do it through PHP, or just a mySQL command i can run through phpmyadmin, because I do not have direct access to the server.

I've looked all around for a script that would do this, and on php.net for some ideas on functions, but everything I tried wasn't working and it's getting to the point where I need major help!

Any input would be great. Thank you.

Weedpacket

Well, I've never used phpMyAdmin (hardly ever use MySQL, frankly), but as far as I can see by Googling for and finding the phpMyAdmin website, and looking at the demo there, I see at the bottom of the main database page a link for "inserting data from a textfile into a table". Does that help?

jcantrell

phpMyAdmin won't do this. The insert data from a text file is looking for a .sql file. Like when you use phpMyAdmin to export a table, or you use the mysqldump from the command line.

I use PHP CSV Importer by Matthew Lindley. The version that I use is 1.3, but when I went looking for the link for you, looks like v2.0 is out now.
http://codewalkers.com/seecode/175.html

Hope this helps!