ODBC connection to LimeSurvey and Excel

More
3 years 6 months ago #99956 by capson
I want to connect excel through a ODBC connection to LimeSurvey is this possible? I have looked in the manual and Googled but have found nothing.

Or if not ODBC is there another way?

Thanks

Please Log in to join the conversation.

More
3 years 6 months ago #99957 by capson
I could not see how to edit my question, more specifically

I want to connect excel through a ODBC connection to the database of individual surveys in LimeSurvey is this possible? I have looked in the manual and Googled but have found nothing.

Or if not ODBC is there another way?

Thanks

Please Log in to join the conversation.

More
3 years 6 months ago #99958 by mdekker
You can only export your responses to excel from within limesurvey.

ODBC is for direct connection to a database but in the case of limesurvey it is difficult to read the database directly. Also most online systems don't allow connections from outside the machine it runs on. So you need to export the responses and open the downloaded file in excel.

---
Menno Dekker
The following user(s) said Thank You: capson

Please Log in to join the conversation.

More
3 years 6 months ago #99980 by capson
Thank you for your response.

Please Log in to join the conversation.