3 ms·
> 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
by magicalhippo 3y ago
> 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.