Programming Data Merging

[canboardrp]

I've got an existing database and for one of the programs I've written, I'm truing to import new data for some of the variables from an excel file. However, I can't figure out how to program that so the final series I end up with is merger of the database series and the excel file series. I'm not sure how clear this explanation is so I've got an example below.

I'm trying to end up with a merged series for CTDDNT. The approach I've been trying is

Code: Select all

'Upload data from database source FETCH(D={%SOURCEDATA}Database\OUTLOOK.EDB) CTDDNT

(Here the series CTDDNT runs from 1978 2000)

Code: Select all

import P:\Test.xls

(Here the series CTDDNT runs from 2001 to 2009)

However when I program it like this, I just get the 2001-2009 series. How can I merge the two?

[EViews Gareth]

Try:

Code: Select all

import(mode=md) p:\test.xls

or try the mode=u option instead.