EViews.com

I am working on a project that requires me to import data from Stata 13 into an Excel spreadsheet, and then from an Excel spreadsheet into EViews. Prior to today, my data set contained values through 2015Q4, and I was hoping to update this data set through 2016Q3. I ran a Stata program that allowed me to transfer values to my Excel spreadsheet, but when I attempted to import this spreadsheet into EViews using a basic import command (import {%xls} range="Tab1" namepos=first), I was thrown an error message indicating that the size of the spreadsheet was not what was expected. Specifically, it shouted about a particular "AppData" folder in one of my local drives that didn't seem to exist after the fact.

Has anyone else had problems importing data from Stata 13 into EViews? If so, have you found any easy solutions? Alternatively, if anyone can make sense of the error that is being thrown, I would appreciate any advice you can give me!

Doesn't answer your specific question, but is there any reason why you cannot read directly from the Stata file into EViews?

Importing into EViews would be best, but if that doesn't work try saving the Excel file under a new name. Lot's of programs don't quite get the internal Excel layout right and EViews gets upset. Resaving often fixes this.

The Appdata complaint may due to a non-existent temporary file directory. EViews needs a writeable directory to store temporary files. If you select Options->General Options and then choose File locations, make sure the directory listed in the Temp File Path box exists.

You might also try this trick -- leave the Excel file open in Excel while you run the IMPORT command in EViews. This will keep the file locked and force EViews to read the data from the running instance of Excel instead of trying to read the data from the file directly.