TRYING TO IMPORT INTO SPSS PROGRAM (Access 2000)

Topic

New Reply

I need help ASAP! I am trying to pull an Access database into a program called SPSS. It keeps asking me for a password and login. What????? I don’t know what to do. Please help.

Reply | Quote

Replies

The login prompt you are getting means that the database has been secured using the Access Security feature. You need to talk to someone who uses the database regularly and see if they can either set up a userid and password for you, or let you use theirs, assuming that they have the necessary priviledges. SPSS – at least in its most recent versions – can read Access tables. If you are working with an older version that doesn’t know about Access 2000 file formats, you may need to export your data to Excel first before you try to pull it into SPSS. Hope this helps.

Reply | Quote

Jennfier,

If you are using v. 10 of SPSS ODBC (Open Data Source), you must establish a login/password for each data file. This “feature/bug” is documeted on spss.com Answer Net. Login/password has to be established for each Access file.

The XL to get to SPSS option will also work though you will want to use an XL format prior to 97/2000 or wk1 or dbf.

If this a task that is to be repeated and you cannot figure out the ODBC login paswword feature, you can create macro to export Access data to comma delimited file and use SPSS Data List syntax command to bring in data and assign variable names and SPSS data formats. This option gets around numerous conversion isssues and can be automated with some advanced techniques (i.e., shell command to execute SPSS and SPSS production facility).

HTH

Reply | Quote