[BNM] nice mysql import tool and free

[Jason Bailey]

Hello,

I've got some rather unclean data in CSV format (not me honest). I've 
succeeded before (about a year ago) and but I'm trying to import the data 
using phpmyadmin. There's an error somewhere and I'm slowly removing them 
but it's a pain. Is there a nice free tool to allow me to import the data 
into mysql and preferably give me decent bad data errors; skipping dodgy 
rows or allowing me to fix/report them.

I've just done the same, as a test, in Oracle with Toad and it was a 
doddle. Anything similar for mysql? I'm wondering whether I should try and 
import into Access and copy over odbc or something?

Jason