Welcome, Guest
Username: Password: Remember me

TOPIC: ODBC connection to LimeSurvey and Excel

ODBC connection to LimeSurvey and Excel 11 months 4 weeks ago #99956

  • capson
  • capson's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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 administrator has disabled public write access.

ODBC connection to LimeSurvey and Excel 11 months 4 weeks ago #99957

  • capson
  • capson's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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 administrator has disabled public write access.

ODBC connection to LimeSurvey and Excel 11 months 4 weeks ago #99958

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
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 administrator has disabled public write access.
The following user(s) said Thank You: capson

ODBC connection to LimeSurvey and Excel 11 months 4 weeks ago #99980

  • capson
  • capson's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
Thank you for your response.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.098 seconds
Donation Image