> I prefer combining SQL with Excel

For so many one-off data importing jobs I just end up generating SQL in Excel after using the text import wizard to get the data into Excel.

It's kinda stupid but it just works so well most of the time. If I sense I might do it again I tend to script it in something more proper tho.