Excel version 2007 & SPSS 15

[wsu_wright]

Having trouble opening into SPSS 15.01 excel files saved in the new version of Microsoft Office excel under the xlsx (rather than xls) format, anyone else having this problem or know of a work around, thanks.

David

[Oliver, Richard]

SPSS 15 does not support the new Excel 2007 xlsx format (AFAIK, the new Excel format was not finalized at the time SPSS 15 was released). You can save Excel 2007 files in the older Excel 2003 xls format, which SPSS can read.

________________________________

From: SPSSX(r) Discussion on behalf of David Wright
Sent: Tue 1/9/2007 4:50 PM
To: [hidden email]
Subject: Excel version 2007 & SPSS 15



Having trouble opening into SPSS 15.01 excel files saved in the new version of Microsoft Office excel under the xlsx (rather than xls) format, anyone else having this problem or know of a work around, thanks.

David

[grump]

Converting to .xls is fine except when you have more than about 65,000 cases. Any other possible solutions?

David Wright-6 wrote

Having trouble opening into SPSS 15.01 excel files saved in the new version of Microsoft Office excel under the xlsx (rather than xls) format, anyone else having this problem or know of a work around, thanks.

David

[Oliver, Richard]

You could save the Excel file in CSV format and then use the Text Wizard to read the CSV file into SPSS.

________________________________

From: SPSSX(r) Discussion on behalf of grump
Sent: Sun 9/21/2008 12:28 PM
To: [hidden email]
Subject: Re: Excel version 2007 & SPSS 15



Converting to .xls is fine except when you have more than about 65,000 cases.
Any other possible solutions?

David Wright-6 wrote:
>
> Having trouble opening into SPSS 15.01 excel files saved in the new
> version of Microsoft Office excel under the xlsx (rather than xls) format,
> anyone else having this problem or know of a work around, thanks.
>
> David
>
>

--
View this message in context: http://www.nabble.com/Excel-version-2007---SPSS-15-tp8248600p19596494.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

====================To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD