Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

ODBC connection to LimeSurvey and Excel

  • capson
  • capson's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 5 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
The topic has been locked.
  • capson
  • capson's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 5 months ago #99957 by capson
Replied by capson on 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
The topic has been locked.
  • mdekker
  • mdekker's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
10 years 5 months ago #99958 by mdekker
Replied by mdekker on 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
The topic has been locked.
  • capson
  • capson's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 5 months ago #99980 by capson
Replied by capson on topic ODBC connection to LimeSurvey and Excel
Thank you for your response.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose