ODBC connection to LimeSurvey and Excel

More
3 years 9 months ago #99956 by capson
capson created the topic: ODBC connection to LimeSurvey and Excel
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 9 months ago #99957 by capson
capson replied the topic: ODBC connection to LimeSurvey and Excel
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 9 months ago #99958 by mdekker
mdekker replied the topic: ODBC connection to LimeSurvey and Excel
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 9 months ago #99980 by capson
capson replied the topic: ODBC connection to LimeSurvey and Excel
Thank you for your response.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now