ok, i have a database that consists several forms and i want to export selected variables from each of the forms. ultimately i want the data to be in SPSS but don't know if it can be exported directly to SPSS. what is the easiest way to do this? i am an access novice so am not sure whether i would need to use a query or just export the variables or what? thanks in advance for any help.
how to export individual variables
- Thread starter acd2
- Start date
- Local time
- Today, 08:58
- Joined
- Feb 28, 2001
- Messages
- 30,991
For a novice, the best way to do what you want is probably through some sort of query that can select the data you want to have in your file. Build the query to display the desired data. It is possible to place criteria in the query but uncheck the SHOW box. That way, the criteria values don't show up in the output. Make this query present the data in the right order based on the columns you need to see. Don't forget that if you need to add a constant or the result of a computation of some sort in the output, you can add a labeled field that has a constant or formula value in the appropriate columen. The resulting value can be exported to the file as easily as the actual data.
Now use the help files to look up keyword Export. You want to export your data to a file, perhaps comma-delimited. (Or perhaps not delimited, I'm not sure about SPSS - it has been literally 25 years since I've been anywhere near that package.) If you have to have some sort of header on the file, think about editing the header into the file after the bulk of your table data has been exported.
Now use the help files to look up keyword Export. You want to export your data to a file, perhaps comma-delimited. (Or perhaps not delimited, I'm not sure about SPSS - it has been literally 25 years since I've been anywhere near that package.) If you have to have some sort of header on the file, think about editing the header into the file after the bulk of your table data has been exported.
Similar threads
