|Date: ||Mon, 31 Jan 2005 12:06:54 -0600|
|Sender: ||"SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>|
|From: ||Karen Gorny <firstname.lastname@example.org>|
|Subject: ||Re: SPSS to Excel|
|Content-Type: ||text/plain; charset="us-ascii"|
SPSS has an Export_to_Excel script that is available on their
Scripting Library web site. You have to log in to the Technical
Support web site, select Utilities->SPSS Scripting Library->Export.
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Monday, January 31, 2005 11:23 AM
Subject: SPSS to Excel
I have a data set of all 50 states for years 1978-2004. I want to run a
report in SPSS that I can then import to Excel in 50 separate
worksheets. I can get the output to separate into one per state (using
split file option) but does anyone know of a way to then import into
Excel into separate worksheets (one per state)? My old method was to
cut and paste each table from SPSS output into a separate worksheet.
Any way to automate this?
700 Broadway Suite 1200
Denver, CO 80203