Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Import excel issues stata12


From   Katherine Sawyer <ks2560@caa.columbia.edu>
To   statalist@hsphsun2.harvard.edu
Subject   st: Import excel issues stata12
Date   Tue, 5 Jun 2012 16:18:56 -0400

Hello, has anyone been able to import an online excel file directly
into stata 12 without saving first?  I need to write a loop to pull
multiple datasets from online, so I am trying to bypass manually
opening and saving them first.  When I try the following code:

import excel http://www.pcr.uu.se/digitalAssets/64/64466_UCDP_DyadicDataset_v12011.xls,
sheet("UCDP DyadicDataset") firstrow clear

I get this error:  file
http://www.pcr.uu.se/digitalAssets/64/64466_UCDP_DyadicDataset_v12011.xls
could not be loaded
r(603);


I have tried many variants of the above syntax.  For example, this
also does not work (returns the same error):


import excel using
http://www.pcr.uu.se/digitalAssets/64/64466_UCDP_DyadicDataset_v12011.xls,
sheet("UCDP DyadicDataset") firstrow clear



I am having no issues importing an excel file I've saved first.  The
following works perfectly:

import excel "C:\Desktop\Uppsala
Data\UCDP_DyadicDataset_v12011_1946_2010.xls", sheet("UCDP
DyadicDataset") firstrow clear



Thank you very much in advance for any help.

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index