Export data file in Access format

Compatibility:IdSurvey 6IdSurvey 7

With IdSurvey you can export all collected data in different formats in the Export Results section of the survey menu. In this article we’ll focus on the Access format.

ACCESS exports always includes all interviews data (a complete database with all information related to the survey), so the buttons “Filter per period” and “Contacts fields” are disabled for this type of export.

export_data_access

Instructions

Click on the “Access” box and then on “Export”. Wait for the exportation to be concluded then click on “Close”. In “Export history” you’ll see the list of all exports done.

Move the Access file you’ve just downloaded into your desktop. Clicking on the file will automatically open it with Microsoft Access.

 

Name of Access tables you can consult are:

 

Appointments: list of appointment scheduled

CallHistory: list of calls made

ContactChanges: contacts fields edited

Contacts

DataRepository

Detail_Result: details of the results

Detail_Result_Temp: details of the results

MailLogs: email log (all no outcome preset emails sent)

Operators: interviewers

Questions

Responses

Results

Surveys

 

Leave A Comment?