export data from database

Post Reply
smckinney
Newbie
Posts: 9
Joined: Wed Oct 28, 2020 3:36 pm

export data from database

Post by smckinney »

what are my options to use switch for exporting data from my database as an xlsx or csv file?
jslater
Member
Posts: 23
Joined: Fri Oct 14, 2011 7:35 pm

Re: export data from database

Post by jslater »

The Database Connect tool can generate a csv log. Do you think that would work for you?
smckinney
Newbie
Posts: 9
Joined: Wed Oct 28, 2020 3:36 pm

Re: export data from database

Post by smckinney »

That's closer.. but it only returns 3 records max. I need all of the records from a selection returned
tvahey
Newbie
Posts: 3
Joined: Mon Feb 07, 2011 9:10 pm

Re: export data from database

Post 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
smckinney
Newbie
Posts: 9
Joined: Wed Oct 28, 2020 3:36 pm

Re: export data from database

Post by smckinney »

That's exactly what I was missing!

Thank you so much!!!! :D
Post Reply