Best way to export SPSS to MySQL database w/labels

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

chrisa107
Posts: 1
Joined: Wed Jan 25, 2012 6:34 am

Best way to export SPSS to MySQL database w/labels

Postby chrisa107 » Wed Jan 25, 2012 6:38 am

I've got tons and tons of .sav files of survey data, containing both the data and the label descriptions. What's the best method of export the SPSS files to an external database (such as MySQL) that maintains the association with the labels for each variable?
RochStatTech
Posts: 8
Joined: Thu Jan 05, 2012 5:29 pm

Re: Best way to export SPSS to MySQL database w/labels

Postby RochStatTech » Mon Jan 30, 2012 9:05 pm

Chrisa107,

You do have an option in the File/Export to Database to export your data file to a particular data source such as SQL, Excel and so on. You do need to setup your Data Source. Verify make sure your Database type and Driver are compatible for Statistics. Then go to Control Panel/Administration Tool/Data Source (ODBC) to do your configuration.



I hope this helps.

Who is online

Users browsing this forum: No registered users and 1 guest

cron