export data from database

[smckinney]

what are my options to use switch for exporting data from my database as an xlsx or csv file?

[jslater]

The Database Connect tool can generate a csv log. Do you think that would work for you?

[smckinney]

That's closer.. but it only returns 3 records max. I need all of the records from a selection returned

[tvahey]

Maybe you are using the free version of the ODBC driver from Actual Technologies?
"Without a license key, the driver will only return the first 3 rows from any query. Once you have purchased a license key, all rows will be returned from your queries."

http://www.actualtech.com/download.php

[smckinney]

That's exactly what I was missing!

Thank you so much!!!!