Unable to open file into SPSS for Windows from MS Excel or MS Word.

Troubleshooting

Problem

Sometimes I get an error message in SPSS that says "A sharing violation has occurred while accessing " whenever I try to read a file from another application, such as MS Excel, or I get a message that says "Error 1216: A file cannot be opened. Probable causes are an attempt to open a read-only file for output, a directory which is too full, an invalid file specification, the specification of a nonexistent disk, etc. This command not executed." When I try to open the file from MS Word. Why can't I read my data?

Resolving The Problem

Applications like MS Excel or MS Word will not allow SPSS for Windows to read a file if that same file is open in the other application. The solution is to close the file out of that other application before opening the file in SPSS

Related Information

Need more help? Visit the IBM Support Forum

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Statistics Server","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"Not Applicable","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

19660

Was this topic helpful?

Document Information

More support for:
IBM SPSS Statistics

Software version:
Not Applicable

Document number:
418209

Modified date:
16 April 2020

UID

swg21476715

IBM Support

Tips