locked
Can I import SPSS files by Power Query without SPSS ? RRS feed

  • Question

  • Can I import SPSS files by Power Query without SPSS ?

    I want to look SPSS files in Excel without SPSS.
    Just like OECD PIAAC 's data.

    OECD = Organisation for Economic Co-operation and Development
    PIAAC = Programme for the International Assessment of Adult Competencies
    data = SAS, and SPSS.

    http://www.oecd.org/site/piaac/publicdataandanalysis.htm



    Regards,
    Yoshihiro Kawabata

    Wednesday, October 9, 2013 1:15 AM

Answers

  • Hi Yoshihiro,

    Thanks for your suggestion. Unfortunately, at this point SPSS files aren't supported in Power Query.

    Regards,
    M.

    Monday, October 14, 2013 3:13 PM
  • Hi Greg,

    Yes, this should definitely be possible now if there is an ODBC driver available.

    Thanks,
    M.

    Wednesday, October 21, 2015 9:09 PM

All replies

  • Hi Yoshihiro,

    Thanks for your suggestion. Unfortunately, at this point SPSS files aren't supported in Power Query.

    Regards,
    M.

    Monday, October 14, 2013 3:13 PM
  • Miguel,

    With enhancements to Power Query to support ODBC, and the availability of an ODBC driver that can access .SAV files, would this now be possible? 

    Thanks,

    Greg Stasko

    Progress Software

    Wednesday, October 21, 2015 2:56 PM
  • Hi Greg,

    Yes, this should definitely be possible now if there is an ODBC driver available.

    Thanks,
    M.

    Wednesday, October 21, 2015 9:09 PM