Forums

Export to Excel (SQL)

Permalink
hi all

i multiple forms and want to extract the answers directly from the database.

i know i can export to excel, but i could do with the SQL code to extract myself.

clicking 'export to excel' takes far too long.

any ideas?

thanks
 
dalmac replied on at Permalink Reply
anybody?

at the minute i have a very basic statement.

select
group_concat(concat(answer,' ',answerlong ))
from btFormAnswers
group by asid
order by asID desc

but it gives a poor, inconsistanct comma delimited result.