Tell me more ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.
up vote 1 down vote favorite

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?

share|improve this question
Is writing a simple Java app an option? Should be easy to do. Admittedly it would JDBC instead of ODBC. – james.garriss 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

3 Answers

up vote 1 down vote

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
share|improve this answer
up vote 1 down vote

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

share|improve this answer
up vote 0 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.