Failed import of Excel data into SPSS 17.0.1

[Thomas Mark-3]

Dear all,

When trying to import data from an Excel 2002 spreadsheet, I get the following message:

 

Error accessing the Excel file. If the file is open in another application, please close it and retry.

 

This occurs when the Excel file is not open. I note on the SPSS website that there was a similar problem with the German version of SPSS, but I have downloaded the patch 17.0.1, and the problem persists. Has anyone encountered this problem?

Many thanks,

Mark Thomas

 

Physician,

Birmingham Heartlands Hospital,

Birmingham, UK

[hidden email]

 

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be
illegal.****************************************************************
******
This email contains proprietary information some or all of which
may be
legally privileged.
It is for the intended recipient(s) only. If an addressing or
transmission
error has misdirected this e-mail, please notify the author by
replying
to
this e-mail.
If you are not the intended recipient you must not use, disclose,
distribute, copy, print, or rely on this e-mail.

Please note, the information contained in this e-mail may be
subject to
disclosure under the Freedom of Information Act 2000 or the Data
Protection Act 1998

This footnote also confirms that this email message has been
swept by a
Borderware Security Platform appliance for the presence of
computer viruses.
www.borderware.com
**********************************************************************

[SPSS Support]

Hello Mark,

  Which machine and operating system were you running? Was the file on a server or on your computer? Have you tried opening it with ODBC, i.e. from File->Open Database?

 

David Matheson

SPSS Statistical Support

 

---

From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Thomas Mark
Sent: Monday, February 02, 2009 11:19 AM
To: [hidden email]
Subject: Failed import of Excel data into SPSS 17.0.1

 

Dear all,

When trying to import data from an Excel 2002 spreadsheet, I get the following message:

 

Error accessing the Excel file. If the file is open in another application, please close it and retry.

 

This occurs when the Excel file is not open. I note on the SPSS website that there was a similar problem with the German version of SPSS, but I have downloaded the patch 17.0.1, and the problem persists. Has anyone encountered this problem?

Many thanks,

Mark Thomas

 

Physician,

Birmingham Heartlands Hospital,

Birmingham, UK

[hidden email]

 

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be
illegal.****************************************************************
******
This email contains proprietary information some or all of which
may be
legally privileged.
It is for the intended recipient(s) only. If an addressing or
transmission
error has misdirected this e-mail, please notify the author by
replying
to
this e-mail.
If you are not the intended recipient you must not use, disclose,
distribute, copy, print, or rely on this e-mail.

Please note, the information contained in this e-mail may be
subject to
disclosure under the Freedom of Information Act 2000 or the Data
Protection Act 1998

This footnote also confirms that this email message has been
swept by a
Borderware Security Platform appliance for the presence of
computer viruses.
www.borderware.com
**********************************************************************