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.



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

  • Would that include field names? Any way to avoid doing it table by table? – pupeno 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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