Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Importing an Excel file directly from https URL
From
Scott Lee <[email protected]>
To
[email protected]
Subject
st: Importing an Excel file directly from https URL
Date
Thu, 25 Apr 2013 23:02:08 -0400
Is it possible to import an Excel file directly into Stata from a
secure (https) URL?
Per http://www.stata.com/statalist/archive/2012-06/msg00394.html , the
following routine works perfectly for the first, unsecure URL, but the
second -copy- gives an "unknown network protocol" (r671) error:
tempfile raw
copy "http://[URL]"; `raw'
import excel `raw'
copy "https://[URL]"; `raw', replace
import excel `raw'
Many thanks for any assistance.
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/