Page 1 of 1

export data from database

Posted: Mon Mar 28, 2022 8:11 pm
by smckinney
what are my options to use switch for exporting data from my database as an xlsx or csv file?

Re: export data from database

Posted: Fri Apr 15, 2022 3:30 pm
by jslater
The Database Connect tool can generate a csv log. Do you think that would work for you?

Re: export data from database

Posted: Wed Apr 27, 2022 7:56 pm
by smckinney
That's closer.. but it only returns 3 records max. I need all of the records from a selection returned

Re: export data from database

Posted: Wed Apr 27, 2022 9:44 pm
by 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

Re: export data from database

Posted: Thu Apr 28, 2022 3:39 pm
by smckinney
That's exactly what I was missing!

Thank you so much!!!! :D