how do i save a large amount of data in a worksheet excel 4

[Rana]

Good morning,
My problem is that the sample i'm working on is of 20,000 observations and
it's an Excel file, when i try to save a copy of my excel file in a
"worksheet Microsoft Excel 4" so i can read it on TSP programm, I loose some
of my observations because the "worksheet Microsoft Excel 4" format cannot
have more than 16 318 rows.
I tried to save my data as a .txt file but it didn't work also cause TSP
couldn't read it, TSP is only able to read data from "worksheet Microsoft
Excel 4".
what can i do to save my large amount of data in such format without loosing
any of my data.
thank you in advance
Rana

[aidan.heritage@virgin.net]

Split your data into two sets of 10,000 records, save each one as excel
4 - it's the only way I can think of to save as Excel 4 and stay within
the limitations of that version.
Rana wrote:
> Good morning,
> My problem is that the sample i'm working on is of 20,000 observations and
> it's an Excel file, when i try to save a copy of my excel file in a
> "worksheet Microsoft Excel 4" so i can read it on TSP programm, I loose some
> of my observations because the "worksheet Microsoft Excel 4" format cannot
> have more than 16 318 rows.
> I tried to save my data as a .txt file but it didn't work also cause TSP
> couldn't read it, TSP is only able to read data from "worksheet Microsoft
> Excel 4".
> what can i do to save my large amount of data in such format without loosing
> any of my data.
> thank you in advance
> Rana

[David Biddulph]

"Rana" <Rana@discussions.microsoft.com> wrote in message
news:1D548A38-8D31-4192-BBA5-67B80FB28AD1@microsoft.com...
> Good morning,
> My problem is that the sample i'm working on is of 20,000 observations and
> it's an Excel file, when i try to save a copy of my excel file in a
> "worksheet Microsoft Excel 4" so i can read it on TSP programm, I loose
> some
> of my observations because the "worksheet Microsoft Excel 4" format cannot
> have more than 16 318 rows.
> I tried to save my data as a .txt file but it didn't work also cause TSP
> couldn't read it, TSP is only able to read data from "worksheet Microsoft
> Excel 4".
> what can i do to save my large amount of data in such format without
> loosing
> any of my data.
> thank you in advance
> Rana

You may have an obsolete version of TSP?
See http://www.tspintl.com/products/tsp/...0new_Jun04.pdf
--
David Biddulph