up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
69% accept rate
feedback

1 Answer

up vote 0 down vote

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

link|improve this answer
Would that include field names? Any way to avoid doing it table by table? – J. Pablo Fernández 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
feedback

Your Answer

 
or
required, but never shown
discard

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