First, be assured that the data are there. If you can not access them then it is likely that your version of Excel is limited to reading in 255 variables. That happens to include all versions of Excel prior to version 2007. You can test this yourself by opening the .csv file in a text editor rather than in Excel. So, how do you access the remaining data if you do not have Excel 2007 or later?
Some things to try:
1. Excel v2007 (clever, no?)
2. Using the SPSS native .SAV data file that ought to be located in your byVariableName data folder. SPSS has no problem with big data files.
3. With a little effort, you can import the .csv file into SPSS like this:
Rename the file from .csv to .txt. Then, in SPSS, select:
Code:
File > New > Data
File > Open
Files of type > Tab-delimited (*.dat,*.txt)
File name <select your file>
Predefined format? No
Delimited? Yes
Variable names at top? Yes
First case = Line 2
Each line represents a case? Yes
All of the cases? Yes
Delimiter? Comma (uncheck all others)
Finish
Again, if you have any trouble reading in the data, you can always look at the data directly in any text editor. If the file is especially large and difficult to read in its raw form, try a powerful free text editor like PSPad from www.pspad.com.