import excel into spss

[csc...@gmail.com]

This is driving me batty. I am trying to open a new spss file from my
excel dataset. It should be idiot-proof, but I keep getting an error
message saying to make sure the excel file is closed (it is). All of
the data are entered only numerically, so that's not it. The only
thing I can think of, is that the excel file is password protected.
Anyone know how to help with this??

[Alice Faber]

In article
<c4d0ddca-d2a9-4227...@m34g2000hsc.googlegroups.com>,
csc...@gmail.com wrote:

Is Excel itself closed?

--
"[xxx] has very definite opinions, and does not suffer fools lightly.
This, apparently, upsets the fools."
---BB cuts to the pith of a flame-fest

[csc...@gmail.com]

On Mar 29, 12:25 pm, Alice Faber <afa...@panix.com> wrote:
> In article
> <c4d0ddca-d2a9-4227-92d9-55bc4da1e...@m34g2000hsc.googlegroups.com>,

oh yes

[djhurio]

Hi,

There are atleast two ways how to import data from Excel.

GET DATA
/TYPE=XLS
/FILE="\\My Documents\Excel_file.xls"
/SHEET=name "Sheet1"
/CELLRANGE=full
/READNAMES=on.

GET DATA
/TYPE=ODBC
/CONNECT="DSN=Excel Files;DBQ=\\My Documents\Excel_file.xls;"
/SQL="SELECT * FROM `Sheet1$`".

Excel file must be closed using the first option. But it can be open
using the second (ODBC) option.

HTH

> oh yes- Hide quoted text -
>
> - Show quoted text -