Wednesday, January 27, 2010

Gr 12 Survey - Extracting data from forms

Email from a teacher - Sorry to bother, but I have done some surveys with my grade 12's. Do you know how to export the "results" to excel/access in 2007?  I could do it in 2003 - convert to txt..... import from excel, but clueless in 2007. Already tried to google it, but no luck.

My response - Go to http://www.studyopportunities.co.za/  Click on FET:  CAT then look at all the 2007 things. There is a document on how to create forms. Now to answer your question - Office button, Word options, Advanced, Preserve fidelity when sharing this document, Save form data as delimited text file.  Phew!

No comments: