File 'C:\Users\MACGIB~1\AppData\ev_temp\hc5.xls' does not match expected format in "IMPORT HTTP://WWW.RBNZ.GOVT.NZ/-/MEDIA/RESERVE ... C5/HC5.XLS RANGE=B5:S450 COLHEAD=1 @FREQ M 1990M12".
The code I am using is:
Code: Select all
pagecreate m 1950m1 2025m6
pagerename untitled monthly
'#### This import statement from the web works fine ######
import http://www.rbnz.govt.nz/-/media/ReserveBank/Files/Statistics/tables/s33/hS33.xls range=Data!b5:ak450 colhead=1 @freq m 2016m12
''#### This import statement from the web fails #######
import http://www.rbnz.govt.nz/-/media/ReserveBank/Files/Statistics/tables/c5/hc5.xls range=Data!b5:s450 colhead=1 @freq m 1990m12
''##### But this import statement works on the file downloaded to my local network ########
import M:\hc5.xls range=Data!b5:s450 colhead=1 @freq m 1990m12
I am confused as to how I can import the file into Eviews from my local network, but not directly from the web.
Any suggestions?