Can anyone recommend any CSV to MySQL conversion tools?

I've got a flatfile database which has a series of fields that I need to import into MySQL.
Most of the fields in the orginal will map to new ones in the MySQL, while some on both sides will be ignored

Any recommendations welcome

__________________
Hosting & Domains|Plesk Vps Hosting|Geek / Cool Stuff|Films.ie|Cool Sites|Monetisation Tips|Movie Chat


Energise your forum! Click here for info

There is a native MySQL LOAD command to load files into DB.

Check out WebmasterWorld Login

__________________
Search Engine Optimisation - Red Cardinal Internet Marketing
Internet Consultant Ireland | Search Engine Optimisation Services
Catering Company Dublin - My sister's handmade canape company!

Unfortunately I need to do more than just load the CSV in if you look at my original post

__________________
Hosting & Domains|Plesk Vps Hosting|Geek / Cool Stuff|Films.ie|Cool Sites|Monetisation Tips|Movie Chat


Energise your forum! Click here for info

This is not a tool as such, but my method for doing this.

If I am reading this correctly you have for example in the csv fields
id, name, address, csvIgnore1, csvIgnore2
and in the mysql fields
id, name, address, mysqlIgnore1, mysqlIgnore2
where you want to map id, name, address, and ignore other fields.

The way I usually do it, is to get all the fields in the csv to match the
fields in the mysql database and then import it using the import tool in phpMyAdmin.

I usually import the cvs into microsoft access (or create a new mysql database) delete the fields I don't want and create the fields to match the existing mysql database. Then export it as csv and do an import in phpMyAdmin to the existing database.

I made something like this a while back for exporting data to CSV, changing it and then importing back in. If you want I'll modify it to let you drop columns etc.

__________________
My New Site/Blog | Check your page for broken links/images/scripts

That would be nice

Aren't there any desktop apps that do this already though?

__________________
Hosting & Domains|Plesk Vps Hosting|Geek / Cool Stuff|Films.ie|Cool Sites|Monetisation Tips|Movie Chat


Energise your forum! Click here for info

There should be. If you don't find anything then the offer's there.

I got it sorted out.. A programmer friend did the import for me

I just have to manually sort out the data

__________________
Hosting & Domains|Plesk Vps Hosting|Geek / Cool Stuff|Films.ie|Cool Sites|Monetisation Tips|Movie Chat


Energise your forum! Click here for info