RSS

Solution for “SPSS Error Code 2063 Getting Data”

29 Sep

Hello all.

Just troubleshot (haha) my way out of an SPSS issue, and since the Interwebs couldn’t help me out, I’ll post it here for anyone else who might need it.

I was trying to import an Excel file that was basically a copy and paste from a different file.  So the file itself was pretty new, not like it’d been worked over a lot.  I tried to import it, however, and got the following error message:

GET DATA /TYPE=XLSX  /FILE=*****
/SHEET=name ‘RawData’
/CELLRANGE=full
/READNAMES=on
/ASSUMEDSTRWIDTH=32767.
>Error.  Command name: GET DATA
>(2063) Error reading information for sheet.
>* Sheet Name: “RawData”
>This command not executed.
DATASET NAME DataSet1 WINDOW=FRONT.

The error, as I could figure out, was probably due to me having calculations lower down in my sheet.  I copied and pasted values into a brand new sheet, and that imported just fine.  If you’re having the same issue, try copy and pasting Values only into a new sheet and see if that helps.

The More You Know…..  ;)

About these ads
 
33 Comments

Posted by on September 29, 2010 in Compy Stuff, Ms. Compy Fix-It

 

Tags: , , , , , , , , , , , , , , ,

33 responses to “Solution for “SPSS Error Code 2063 Getting Data”

  1. Eduard

    October 13, 2010 at 7:11 pm

    Thank you.
    It worked :)
    Wish you all the best ! :)

     
    • clio44

      October 13, 2010 at 8:30 pm

      Wonderful — glad I could help! :)

       
    • Geoff

      January 12, 2011 at 5:31 pm

      Worked perfectly! You’re a wonderful person for posting this.

       
      • clio44

        January 12, 2011 at 5:42 pm

        Aww, thanks Geoff. I’m truly glad I could help :)

         
  2. Sig

    October 28, 2010 at 12:33 am

    Had the same problem. Apparently I solved it by saving the excel file in 2003-oder format.
    sig

     
    • clio44

      October 28, 2010 at 4:14 pm

      Interesting! I’ll try that next time and see if that does anything to the equations….. Thanks for the idea!

      By the way, your name/e-mail looks really familiar….. did you by chance post somewhere else about this? (Or have you visited my site before?)

       
    • Koori

      June 24, 2013 at 6:48 am

      Thanks for the solution! I did the copy solution and didn’t help, but your solution work just fine. =D

       
  3. Eline

    November 2, 2010 at 10:32 am

    Thanks a lot! You saved me from a whole (lost)day looking to solve the problem :)

     
  4. Eline

    November 2, 2010 at 10:51 am

    Can you perhaps solve my next problem? I have numbers like 0,7890437 in excel, but SPSS gives them as 0,0000
    Do you know what happened here?

     
    • clio44

      November 2, 2010 at 3:28 pm

      First of all, thanks so much for writing — I’m very glad to help :)

      As to your other issue, I’m wondering if it might have to do with the decimal (these are decimal entries, right?) being represented as a comma. Try readjusting your number format in Excel first, copy-pasting values only into a new file or sheet, and importing that way. Good luck, and let me know how it goes! :)

       
  5. matS

    November 16, 2010 at 7:10 pm

    This has often to do with importing an Excel 2007 file. In case this is true, just open your Excel file and store it in the Excel 97-2003 format.
    Then try importing it with SPSS… it always worked for me.

     
    • Ed Hindess

      May 24, 2013 at 6:30 pm

      Yeah, Thanks a lot, it really does not work in *.xlsx-Format but in *.xls – Strange, but ok…

       
  6. Erinn

    December 2, 2010 at 7:55 pm

    I googled help for this error and I got your post! What are the odds? Thanks so much! It’s so weird that copying and pasting values into the same sheet doesn’t work.

     
    • clio44

      December 2, 2010 at 10:31 pm

      That’s funny! Although I’ve found a lot of SPSS help is in the form of posts from users (versus actual company help)….. that’s why I post when I come up with a solution! Glad to help Erinn, hope you’re doing well :)

       
  7. brenden

    December 5, 2010 at 12:38 am

    That worked great! Thank you so much! Back to analyzing energy savings from bill data…

     
  8. Quinton

    February 12, 2011 at 3:46 am

    After messing with syntax for 6+ hours today, then all of a sudden running into an issue with an excel file not reading (after it has been reading fine for months) words cannot express how relieved I am to have found such a quick fix. THANK YOU!

     
    • clio44

      February 12, 2011 at 7:23 pm

      I’m so glad to have helped! Thank you for commenting, you just made my day! :D

       
  9. Peter

    February 25, 2011 at 9:46 am

    Please anyone help – I administered a survey with two 4 point likert scale reponses to one statement – one demand and the other supply – I want to use SPSS Ver 18 to analyse the Gap – Using Julie Pallant book but to no avail.

    Thanks in anticipation

     
    • clio44

      February 25, 2011 at 3:00 pm

      Are you thinking of doing a correlation?

       
  10. Elsa

    March 2, 2011 at 9:39 pm

    Hi! Interesting, what works for me, was to save spreadsheet as 97-2003. I´m new at using spss. And this blog was really helpful!

    Thanks :D

     
  11. Anne

    March 9, 2011 at 2:21 pm

    Thank you! Just had this problem – and yes, you fixed it!

     
  12. xof

    June 1, 2011 at 6:35 am

    Try saving your excel files as txt tab delimited – if you have bigger data (more than 65k rows and smth about 256 cols) than you cannot do it as xls (97/2003)

     
  13. Elaine

    June 21, 2011 at 4:22 pm

    Add me to the list of people who you helped with this problem. Thank you!

     
  14. Melody

    July 12, 2011 at 8:56 am

    Thanks for all the pointers of help – another person to add to the list of people you have helped with this problem of error code 2063. Saving to a text tab file helped for me!

     
    • clio44

      July 12, 2011 at 4:09 pm

      Great to hear! Glad I could also help you, Elsa, Anne, and Elaine! I had no idea this many people would have this issue, so I’m very glad I posted it. Kinda draws all us SPSS-ers together in a way ;)

       
  15. Alli

    November 4, 2011 at 9:26 pm

    Thank you, Thank you , Thank you!!!!

     
    • clio44

      May 24, 2012 at 7:40 pm

      You’re welcome, you’re welcome, you’re welcome! :)

       
  16. MJ

    May 1, 2012 at 3:15 pm

    it worked! thanks!

     
    • clio44

      May 24, 2012 at 7:40 pm

      So glad to hear it!

       
  17. LW

    May 24, 2012 at 7:16 pm

    Thank you so much! This is a really great help for a typical student who runs late with essay assignments!

     
    • clio44

      May 24, 2012 at 7:41 pm

      You’re welcome :)
      I understand your pain!! Good luck :)

       
  18. Nata Chaipichit

    December 4, 2012 at 12:18 am

    just copy and save as excel 2003 in a new file. It works! Thanks

     
  19. Nik

    February 1, 2013 at 11:44 pm

    Thanks Heaps! That was really helpful!

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 165 other followers

%d bloggers like this: