Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Canada
    Posts
    284
    Thanks
    0
    Thanked 0 Times in 0 Posts

    TRYING TO IMPORT INTO SPSS PROGRAM (Access 2000)

    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.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: TRYING TO IMPORT INTO SPSS PROGRAM (Access 2000)

    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.
    Wendell

  3. #3
    New Lounger
    Join Date
    Nov 2001
    Location
    Virginia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: TRYING TO IMPORT INTO SPSS PROGRAM (Access 2000)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •