I have the following syntax which takes data from my FUM QVD every month. Now instead of the new data overwriting what I already have in the below table, I want the new data to be appended to the bottom instead...can someone PLEASE let me know how to script this as I'm pulling my hair out?!!
Let me make sure if I have understood the requirement. You wanted to load only new data from QVD instead of all the historical data... is this right? If yes, I would recommend using functions like RowNo() and RecNo() inyour QVD Load Script. Then you can store the most recent RowNo() or RecNo() ina script variable. Once you have this variable in your load script you can do the conditional load by using the “Where” clause. This way you are always loading the most recent data.
Thats not quite right due to the way the data is set up, let me explain a bit further:
I have a DB which holds the current months FUM (Funds Under Management) data (about 500,000 records each month). The DB doesn't hold historical data as there's too much for Access to handle, therefore all I'll ever be loading to the QVD is the latest months worth of data.
That means I basically want to take everything from the QVD and append it to the bottom of what I already have in my QVW table, does that make sense. The QVD will hold only new data each time it's refreshed.