Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SQL Anywhere 5 database which I can currently access through ODBC. I managed to open it with Access but when I used Access to export text files it would truncate the data.

Is there a way with Access or any other tool to easily export all tables to a bunch of CSV files with field names as the first row and the table names as the file names, or something like that?

I'm not familiar with Access (which is installed in a language I don't understand), ODBC or even Windows in general; so, don't hesitate to point to obvious solutions, I probably missed them.


share|improve this question

You can use an ISQL CLient and then export to CSV as discussed in SO HERE.

share|improve this answer
Would that include field names? Any way to avoid doing it table by table? – Pablo Jun 23 '11 at 10:41
This will not include field names "SELECT * FROM SomeTable; OUTPUT TO 'C:\temp\sometable.csv' FORMAT ASCII DELIMITED BY ';' QUOTE ''" but you will have to do it table by table. Let me have a poke around and see is there a better solution. – slotishtype Jun 23 '11 at 11:03
There is also this, which may be of use at some point. – slotishtype Jun 23 '11 at 11:46

You must log in to answer this question.

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