EasyCSV is a windows application that lets you run SQL quieres against any csv file. The output is stored in another csv file. This means you can do data manipulation on the fly without going through the tedioum of importing it into a real data base, and exporting it out again from a temp table.
Gotchas: EasyCSV doesn't like
CAST( field as varchar(255)). Use
CSTR(field) instead. This is because the underlying ODBC text driver doesn't fully support SQL-89 (thanks microsoft!).