1

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?

3
  • Is writing a simple Java app an option? Should be easy to do. Admittedly it would JDBC instead of ODBC. Feb 6 '12 at 13:47
  • @Mark - From my (windows) experience with Navicat Premium, it can only export data from MySQL, SQL server, PostgreSQL. You can import data from ODBC to one of said DBs and then export it to CSV as a workaround.
    – Vlad
    Feb 8 '12 at 9:20
1

Most scripting languages should be able to do this e.g. python, perl, tcl,

Python does this with

  1. AN odbc pachkage - see Python wiki
  2. csv package in the standard library
1

Razor SQL has a fully functional 30-day trial which would be ok for one-time uses.

0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .