Upload csv or MSAccess file to MySQL

[surfgatinho]

Hi
Any suggestions how I can allow a user to update a MySQL database using a .csv (or any other MSAccess compatible file). I know there is a command line on MySQL for importing delimited files but how do I run this from a PHP script.

Thanks
Chris

[sarahk]

If you are just doing inserts try adding the following to a new column in Excel

="insert into tableX (col1, col2) values (" + A1 + ",'" + A2 + "');"

to create your own insert statements which can then just be pasted into mysql or put into a text file which it runs.

use Ctrl+D to paste into each row.