Date:         Mon, 19 Jun 2006 15:16:07 -0400
Reply-To:     Siraj Ur-rehman <Siraj.Ur-rehman@Ipsos-ASI.com>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Siraj Ur-rehman <Siraj.Ur-rehman@Ipsos-ASI.com>
Subject:      Re: Exporting to Separate Excel Sheets
Content-Type: text/plain; charset="us-ascii"

I copied my syntax which I am using by the help of Richard.

Siraj

GET FILE='K:\Data\SPSS\dbo_tb_survey_information-SPSS.sav'.

select if (quarter=1).

SAVE TRANSLATE
 /CONNECT='DSN=Excel Files;DBQ=C:\Documents and Settings\Desktop\SPSS
Testing\Avaya.xls;DriverId=790;MaxBufferSize=2048;PageTimeout=5;'
 /TABLE="Quarter1"
 /TYPE=ODBC
 /REPLACE.
exe.

*******************Richard's email****************************.

From: Oliver, Richard [mailto:roliver@spss.com]
Sent: Tuesday, March 28, 2006 3:21 PM
To: Siraj Ur-rehman; SPSSX-L@LISTSERV.UGA.EDU
Subject: RE: Different Excel file in one Master file

If by "master file" you mean a single workbook with multiple worksheets,
Ray Levesque just showed me how to do this using SAVE TRANSLATE
TYPE=ODBC, specifying the sheet names on the TABLE subcommand. The only
really tricky part is figuring out the correct connect string --
although you can obtain this by using the Database Wizard to read any
Excel file, paste the syntax, and then copy the connect string, changing
the Excel file specification to whatever you want. Everything but the
worksheet name specified on the TABLE subcommand should be the same for
each Save Translate command.

************************************************************************
********




-----Original Message-----
From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU] On Behalf Of
Hughes, John
Sent: Monday, June 19, 2006 3:03 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Exporting to Separate Excel Sheets

I need to be able to save subsets of my file into separate sheets within
a single excel file (i.e. one worksheet per county). I cannot see how to
do this using the save translate command. Does anyone have a suggestion?



Thanks,

John Hughes

Agency for Workforce Innovation, Florida.