Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Newbie question
- Thread starter eussias
- Start date
- Thread starter
- #3
To familiarize yourself with how this works, open excel, and in a new workbook select Data>Get external data>new database query...then a choose data source box will open, in the databases tab select MS Access database* then follow the wizard from there till you successfully return your data to excel.
Then find the equivelant proceedure in you stats package (it should be somewhat similar) ....If no luck, you may have to create a DSN, if so, i'll walk you through that!
Then find the equivelant proceedure in you stats package (it should be somewhat similar) ....If no luck, you may have to create a DSN, if so, i'll walk you through that!
- Thread starter
- #5
Thanks for that... my problem is though, I have never used this stats package before, and probably never will. One of my colleagues uses it all the time, but he doesn't seem to know anything about how best to export the Access file. I'm nearing the end of a contract here, and just wanted to get this last thing complete. Is there any way of doing this if I have never seen this stats package before? Thanks in advance for any help... 
- Thread starter
- #7
check out this FAQ
Q. I have an SPSS system file that I would like to use in another application, such as Microsoft Access. What do I need to do?
A. Most applications cannot read a SPSS system file directly. However, you have several options, depending on the types of files that the application can use.
1. If the application can read tab delimited, fixed ASCII, Excel or dBase files, then you can save the system file out of SPSS in one of those formats, using File->Save As. Select the type of file from the Save As Type drop down list. However, Excel and dBase both have limitations on how many cases and variables can be saved in one file. The following size limitations apply for these file types:
Excel - 255 variables and 16,384 cases. SPSS saves out an Excel version 2 file.
dBase IV - 255 variables and 1 billion cases, subject to disk space. Earlier versions of dBase can hold fewer cases.
2. If the application is ODBC compliant, which would include most modern database programs, then you can use the SPSS Data Driver 32. The SPSS Data Driver allows ODBC compliant applications to read SPSS system files directly, via ODBC. The SPSS Data Driver 32 is included in the SPSS Data Access Pack on the SPSS 10.0 CD-ROM. To install the driver, insert your SPSS CD-ROM. The autoplay screen should appear. Click on Install SPSS Data Access Pack. At the first screen, click Next, and then accept the license agreement. At the next screen, you can select the location where you want the files to be installed. Then click Next. At the Select Components screen, check the box next to SPSS Data Driver 32. Then, click Next and follow the remaining steps in the wizard. This will install the SPSS Data Driver into your ODBC Data Sources Control panel.
To configure the driver, go to Start->Settings->Control Panel. Double click on Data Sources (ODBC). On the User DSN tab, click Add. Scroll down until you see SPSS Data Access 32 (*.sav), and select it. Click Finish. A small dialog box will appear, named Setup. In the box next to Data Source: type in a name for the Data Source. In the box next to Database: type in the full path to the directory where you SPSS data file is located. Then click OK. Click OK again on the Database Administrator. When you use the data source within your application, the driver will display each SPSS data file in the directory as a separate table. In general, ODBC can only read in 255 variables at a time.
Q. I have an SPSS system file that I would like to use in another application, such as Microsoft Access. What do I need to do?
A. Most applications cannot read a SPSS system file directly. However, you have several options, depending on the types of files that the application can use.
1. If the application can read tab delimited, fixed ASCII, Excel or dBase files, then you can save the system file out of SPSS in one of those formats, using File->Save As. Select the type of file from the Save As Type drop down list. However, Excel and dBase both have limitations on how many cases and variables can be saved in one file. The following size limitations apply for these file types:
Excel - 255 variables and 16,384 cases. SPSS saves out an Excel version 2 file.
dBase IV - 255 variables and 1 billion cases, subject to disk space. Earlier versions of dBase can hold fewer cases.
2. If the application is ODBC compliant, which would include most modern database programs, then you can use the SPSS Data Driver 32. The SPSS Data Driver allows ODBC compliant applications to read SPSS system files directly, via ODBC. The SPSS Data Driver 32 is included in the SPSS Data Access Pack on the SPSS 10.0 CD-ROM. To install the driver, insert your SPSS CD-ROM. The autoplay screen should appear. Click on Install SPSS Data Access Pack. At the first screen, click Next, and then accept the license agreement. At the next screen, you can select the location where you want the files to be installed. Then click Next. At the Select Components screen, check the box next to SPSS Data Driver 32. Then, click Next and follow the remaining steps in the wizard. This will install the SPSS Data Driver into your ODBC Data Sources Control panel.
To configure the driver, go to Start->Settings->Control Panel. Double click on Data Sources (ODBC). On the User DSN tab, click Add. Scroll down until you see SPSS Data Access 32 (*.sav), and select it. Click Finish. A small dialog box will appear, named Setup. In the box next to Data Source: type in a name for the Data Source. In the box next to Database: type in the full path to the directory where you SPSS data file is located. Then click OK. Click OK again on the Database Administrator. When you use the data source within your application, the driver will display each SPSS data file in the directory as a separate table. In general, ODBC can only read in 255 variables at a time.
- Status