Greetings, and sorry for writing in English (you can reply in German). I have a similar problem than peter.neu:
I have a list of about 200 crops on a column, and for each crop I have 6 information (income, amount of land, season, etc.) in the following columns. I have this information for about 100 households in 6 villages.
I am now starting to put these info in the computer, and it is an enourmous task. I thought that one way to do it is to input the data into Excel, and have one file per village, and in each file one sheet for each household (I could name each sheet after the household head). I then want to analyse the data at the household level for each village, and also analyse the data at the village level (after calculating village averages).
My question is: Can I transfer easily the files to SPSS, and use SPSS to compare the different households?
I read the help menu in the SPSS software, and it seems to me that SPSS automatically selects only the first sheet from an excel file with many sheets? Is that really so?
Alternatively, shall I enter the data in SPSS or in Access? I haven't started entering the data, so I can still select the software I want.
If anybody can help, I would be very grateful. This is actually very urgent, because I am going to pay somebody to do it, but I have to tell her how to do it over the week-end. Thank you very much!!