|
Home > Archive > Getting Started with dBASE > February 2006 > SPSS ODBC Import Data Editor Hang with Wide Files from dBase
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SPSS ODBC Import Data Editor Hang with Wide Files from dBase
|
|
| Carl Norris 2006-02-17, 7:24 am |
| When I try to open a wide .dbf table (created by dBase plus) with more than 300 fields in the record by using the SPSS FILE, OPEN DATABASE, NEW QUERY function, the SPSS data editor hangs and I get a \\\"program not responding\\\" message. The SPSS data ed
itor seems to be able to import smaller tables created by dBase using this procedure so I know the connection is working. I have tried using both the Microsoft OCBC driver for dBase and the SPSSS dBase driver and get the same hang with each of them.
My main reason for using dBase is that the number of fields per record is 1024 (not 255 like ACCESS, Foxpro, etc.), but I need to get this data out and into SPSS to look at it. Can anyone suggest why this hang is occurring or how I can work around it. I a
m running on a Dell 8250 with XP service pack 2 with 512 megs ram. I have tried this on a similarly configured Dell laptop wtih the same problem occurring.
Any suggestions would be appreciated. A copy of the problem file I am trying to get into SPSS is attached.
Thanks,
Carl
| |
| Tim MacAlpine 2006-02-17, 7:24 am |
| Your file is a level 7 table. I don't think that Microsoft or SPSSS has
drivers for this level. Existing drivers support up to level 4 tables, I
think. You may have to convert the table to a lower level.
Tim MacAlpine
"Carl Norris" < carlnorris@sbcglobal
.net> wrote in message
news:ryhmME1MGHA.592@news-server...
> When I try to open a wide .dbf table (created by dBase plus) with more
than 300 fields in the record by using the SPSS FILE, OPEN DATABASE, NEW
QUERY function, the SPSS data editor hangs and I get a \\\"program not
responding\\\" message. The SPSS data editor seems to be able to import
smaller tables created by dBase using this procedure so I know the
connection is working. I have tried using both the Microsoft OCBC driver for
dBase and the SPSSS dBase driver and get the same hang with each of them.
>
> My main reason for using dBase is that the number of fields per record is
1024 (not 255 like ACCESS, Foxpro, etc.), but I need to get this data out
and into SPSS to look at it. Can anyone suggest why this hang is occurring
or how I can work around it. I am running on a Dell 8250 with XP service
pack 2 with 512 megs ram. I have tried this on a similarly configured Dell
laptop wtih the same problem occurring.
>
> Any suggestions would be appreciated. A copy of the problem file I am
trying to get into SPSS is attached.
>
> Thanks,
> Carl
>
|
|
|
|
|