Is there a way I can connect to a data source via ODBC and export the data to a CSV file on the mac? Open-source software to do this would be great, otherwise is it possible from the command-line?
Razor SQL has a fully functional 30-day trial which would be ok for one-time uses.
I spent several days trying to get this to work for a client. There are lots of ODBC drivers and SQL software packages that promise to do it, but in the end I had to run a virtual machine of Windows and Office 2010 to get this to work.
Not really sure why, but just wanted to let you know what I had to do to get it to work.