excel read in and match

[seahorse]

Hi folks,

Simple question I think but it is baffling me as there are lots of import commands. I have an eviews file with many pages in it and I would like to update the file with new data I have in Excel. To create the model I used code to readin lots of data and give it a range of attributes. When I try and import the updated data it creates new series rather than updating the existing ones. I hope that makes sense! I have attached the Excel and the Eviews of one of the sheets as an example. Basically I need code that can update the eviews variables with the new data in Excel (I have about 30 of these sheets so I will loop it all through once I can master doing it for one)

Thanks in advance

NG

[EViews Gareth]

Something like:

Code: Select all

import(mode=o) c:\temp\defs.xlsx colhead=11 namepos=first @freq a @id @date(variable_code) @destid @date