Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Import SPSS .Sav file
- Thread starter starnold
- Start date
What format is a SPSS .Sav file in? Is it a text file? Is it delimited by anything (tab, comma, period, etc.)?
If it is a delimited file, you can use the Import Wizard (right click your database and go to All Tasks -> Import Data or Tools -> Wizards or Data Transformation Services -> All Tasks -> Import Data) to transform it from a delimited file to a SQL Server table. Look in Books Online under DTS Import/Export Wizard for more info.
There is a box with elipses (...) on it at some point in the wizard (depending on the options you use) which allow you to specify what datatype you want your imported data to become. I don't see a .SAV option in the Source box, but I do see an Other (ODBC Data Source) option you can use, or you can export your .SAV file to a delimited text file and then use the Text File import option in the wizard.
If you choose the export to text file option before importing to SQL, I would choose a delimiting character that is noticable. I don't like using "tab", but if you use comma or period and some of your fields actually contain a comma or a period, then you'll have a field separation problem.
Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!
If it is a delimited file, you can use the Import Wizard (right click your database and go to All Tasks -> Import Data or Tools -> Wizards or Data Transformation Services -> All Tasks -> Import Data) to transform it from a delimited file to a SQL Server table. Look in Books Online under DTS Import/Export Wizard for more info.
There is a box with elipses (...) on it at some point in the wizard (depending on the options you use) which allow you to specify what datatype you want your imported data to become. I don't see a .SAV option in the Source box, but I do see an Other (ODBC Data Source) option you can use, or you can export your .SAV file to a delimited text file and then use the Text File import option in the wizard.
If you choose the export to text file option before importing to SQL, I would choose a delimiting character that is noticable. I don't like using "tab", but if you use comma or period and some of your fields actually contain a comma or a period, then you'll have a field separation problem.
Catadmin - MCDBA, MCSA
Remember, "Work" is a four letter word. And you know what your mother told you about using four letter words!
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question