Updating Data Imported from Excel

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

moameen
Posts: 7
Joined: Wed Aug 01, 2012 3:15 am

Updating Data Imported from Excel

Postby moameen » Wed Aug 01, 2012 4:12 am

I have created an EViews workfile by importing data from Excel using Foreign Data as Workfile, under File/Open. I now have new datapoints in excel and would like to update the EViews workfile for the data. I can see the excel link in the workfile and in each individual dataset, but can't seem to update this data.

How do I get the updated excel data into the existing workfile?

Thanks.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Updating Data Imported from Excel

Postby EViews Gareth » Wed Aug 01, 2012 4:39 am

There is no way to do that other than by re-importing the data from Excel.

moameen
Posts: 7
Joined: Wed Aug 01, 2012 3:15 am

Re: Updating Data Imported from Excel

Postby moameen » Wed Aug 01, 2012 5:18 am

Thank you for the reply. I am a new user so please bear with the basic questions:

1) Can i re-import the data in the same workfile? If I can't, it seems like my models will be static, something one of the unnamed course providers failed to mention!

2) How would I set-up a workfile where I can import and update data excel data on an on-going basis i.e. linked to excel worksheets?

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Updating Data Imported from Excel

Postby EViews Gareth » Wed Aug 01, 2012 8:48 am

File->Import let's you bring into the same workfile (assuming you have EViews 7)


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests