Dear all,
I wanted to read an EXCEL sheet into SPSS with the following command:
GET DATA
/TYP=XLS
/FILE= 'Voor_Marijke.xls'.
However, I received this error message:
*>Error. Command name: GET DATA
*>(2052) Error accessing the Excel file. The file may be open by another
*>application. If so, close it and retry.
*>* File: ""
However, the file wasn't open at all. When I read the data using the GUI, the following syntax (retrieved from the journal file) worked perfectly:
GET TRANSLATE
FILE='\\Fs03\a1500\PROJECT\Models&Methods\Aug_09\ABN\ABN_5\Voor_Marijke.xls'
/TYPE=XLS /MAP /FIELDNAMES .
According to the command syntax reference, GET TRANSLATE should be used for EXCEL version LE 4 and GET DATA for EXCEL version GE 5. We're using EXCEL version 10. Does anybody understand why GET TRANSLATE works and GET DATA doesn't??
TIA!!
Ruben van den Berg
See all the ways you can stay connected
to friends and family
Locked
