Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Won't let me import excel file into stata. please help

    Stata won't let me import a dataset from excel. It's saying that the file is too new to be run by this version of Stata and so was ignored. However I saved the excel as an older version and it still gave me the same error message. Can you please help? I have had such a terrible time downloading stata and now I can't even use it. I'm using a mac.

  • #2
    Where did you download Stata from?

    What versions of MS Excel file and Stata are you using?
    You should:

    1. Read the FAQ carefully.

    2. "Say exactly what you typed and exactly what Stata typed (or did) in response. N.B. exactly!"

    3. Describe your dataset. Use list to list data when you are doing so. Use input to type in your own dataset fragment that others can experiment with.

    4. Use the advanced editing options to appropriately format quotes, data, code and Stata output. The advanced options can be toggled on/off using the A button in the top right corner of the text editor.

    Comment


    • #3
      If everything else fails, read the manual.
      If that also fails, read the FAQ of Statalist on how to ask questions.
      Best, Sergiy

      Comment


      • #4
        Stata is 13.1 and MS excel is 2010

        Comment


        • #5
          I have no trouble importing a MS Excel 2010 file with Stata 13.1 (Revision 06 May 2014). My guess is many people here wouldn't be able to reproduce your problem. So unless you follow Sergiy's advice, I think it's difficult to help.
          You should:

          1. Read the FAQ carefully.

          2. "Say exactly what you typed and exactly what Stata typed (or did) in response. N.B. exactly!"

          3. Describe your dataset. Use list to list data when you are doing so. Use input to type in your own dataset fragment that others can experiment with.

          4. Use the advanced editing options to appropriately format quotes, data, code and Stata output. The advanced options can be toggled on/off using the A button in the top right corner of the text editor.

          Comment


          • #6
            I think I had the same issue using the 06 May 2014 version. I updated to the 26 Jun 2014 version and the problem went away. If you simply type "update all" in the Stata command line that should solve your problem.
            Best,
            Jamie

            Comment


            • #7
              Jamie, the original poster mentioned that he created the file with the Excel product from the Microsoft Office 2010. The relevant changes from the whatsnew update only mention Excel files produced by Apple Numbers for Mac. So either the problem that was fixed by StataCorp is not described correctly in the description of the updates, or there is a different problem that prevents the import. The topic starter for no obvious reason does not post the commands she typed, nor the actual response of Stata. From what I see I can't even exclude a possibility she is trying to run an Excel file in Stata. Best, Sergiy

              Comment


              • #8
                The update worked, Jamie. Thank you for your help. I was simply trying to import a file, no reason I need to read a manual for that and I don't see how I could have asked that question any differently...but thanks.

                Comment


                • #9
                  Originally posted by arunner View Post
                  I was simply trying to import a file, no reason I need to read a manual for that ...
                  I believe there is no such thing as a too-simple-an-operation so that it doesn't merit a help <command> or a manual read when errors creep in.

                  Originally posted by arunner View Post
                  and I don't see how I could have asked that question any differently...
                  I think this is different:
                  I can't import a MS Excel file using Stata 13, Revision x. The code I'm running and the error are:

                  <some code copied from the results window>
                  <some error copied from the results window>

                  The MS Excel file was given to me by a fellow <student, etc.> so I can't say how it was produced (software other than MS Excel can produce these files, e.g. LibreOffice). It appears to be MS Excel 2010 version. I'm using a Mac.

                  I tried saving the file as an older version using <this and that method> but I kept getting the same error.

                  Any ideas as to what the problem may be?
                  You should:

                  1. Read the FAQ carefully.

                  2. "Say exactly what you typed and exactly what Stata typed (or did) in response. N.B. exactly!"

                  3. Describe your dataset. Use list to list data when you are doing so. Use input to type in your own dataset fragment that others can experiment with.

                  4. Use the advanced editing options to appropriately format quotes, data, code and Stata output. The advanced options can be toggled on/off using the A button in the top right corner of the text editor.

                  Comment


                  • #10
                    arunner: Roberto and Sergiy are right. Next question you have, please read the FAQ Advice first. That way, the answer is likely to come faster and to be closer to what you want from the outset.

                    Comment

                    Working...
                    X