CSV / MySQL Tools?

Does anyone know of a tool for working with CSV files and then importing them into MySQL?
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
There’s about a thousand entries in the database, so I’d rather not do it manually, as it’s not simply a matter of copying and inserting – I will also have to manually change one element associated with each entry….
Any suggestions would be welcome if they run on windows or linux (I don’t have OSX yet)