Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

Thanks.

share|improve this question

1 Answer 1

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

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.