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!!!!  
