st: Import excel issues stata12

[Katherine Sawyer <ks2560@caa.columbia.edu>]

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/