| Date: | Tue, 14 Nov 2000 08:44:52 -0600 |
|---|
| Reply-To: | "Sanders, Tina" <Tina.Sanders@TELECHECK.COM> |
|---|
| Sender: | "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Sanders, Tina" <Tina.Sanders@TELECHECK.COM> |
|---|
| Subject: | Re: Excel row limits |
|---|
| Content-Type: | text/plain; charset="iso-8859-1" |
|---|
In Excel 97, the limit is somewhere between 65,000 and 66,000 rows.
-----Original Message-----
From: Raynald Levesque [mailto:rlevesque@VIDEOTRON.CA]
Sent: Monday, November 13, 2000 6:35 PM
To: SPSSX-L@LISTSERV.UGA.EDU
Subject: Re: Excel row limits
Hi
I believe the maximum is about 16,000 lines in Excel (I am
using excel 97).
A way around the limitation is to export from Excel to a tab
delimited
format file. This is then easily imported from SPSS and
there are no limits
on the number of records.
HTH
Ray
----- Original Message -----
From: "Uhles, Greg" <greg.uhles@EDS.COM>
Newsgroups: bit.listserv.spssx-l
To: <SPSSX-L@LISTSERV.UGA.EDU>
Sent: Monday, November 13, 2000 3:55 PM
Subject: FW: Excel row limits
> Are SPSS queries limited by Excel spreadsheet row
limitations? Are there a
> max number of rows of data that can be returned?
|
