Date:         Mon, 31 Jan 2005 12:06:54 -0600
Reply-To:     gornykm@comnetcom.net
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Karen Gorny <gornykm@comnetcom.net>
Subject:      Re: SPSS to Excel
In-Reply-To:  <3A9E375AF395774E8BF7211238D97A402CFAF6@fsmail.SHEEOPRIV.local>
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.

Karen

-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Tara Bisel
Sent: Monday, January 31, 2005 11:23 AM
To: SPSSX-L@LISTSERV.UGA.EDU
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?







Tara Bisel

Data Analyst

SHEEO

700 Broadway Suite 1200

Denver, CO 80203

303-299-3682

303-299-9016 (fax)

tbisel@sheeo.org