[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: importing Microsoft Office Excel files into PSPP
From: |
Alan Mead |
Subject: |
Re: importing Microsoft Office Excel files into PSPP |
Date: |
Tue, 12 Nov 2019 08:57:21 -0600 |
User-agent: |
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.9.0 |
I don't think that's supported. In the past, the advice has been to save
the XLSX file as a supported format (ODT or delimited file) and import that.
I recommend doing this for SPSS as well, because when I import an Excel
file directly in SPSS, it makes guesses about variable types/lengths
that I frequently don't like. I've had it guess wrong about string
length causing data loss. That seems ridiculous.
-Alan
On 11/12/2019 8:47 AM, Dr Richard Fiene wrote:
> Has anyone had problems in importing Microsoft Office Excel files into PSPP?
> *__________________________*
> *Richard Fiene, Ph.D., Research Psychologist*
> [image: iD icon]*orcid.org/0000-0001-6095-5085
> <https://orcid.org/0000-0001-6095-5085>*
> *The Pennsylvania State University*
> *Research institute for Key Indicators*
> *National Association for Regulatory Administration*
--
Alan D. Mead, Ph.D.
President, Talent Algorithms Inc.
science + technology = better workers
http://www.alanmead.org
"A human being should be able to change a diaper, plan an
invasion, butcher a hog, conn a ship, design a building,
write a sonnet, balance accounts, build a wall, set a bone,
comfort the dying, take orders, give orders, cooperate,
act alone, solve equations, analyze a new problem, pitch
manure, program a computer, cook a tasty meal, fight
efficiently, and die gallantly. Specialization is for
insects."
-- Robert A. Heinlein