Loading Monthly data into a QVD file

[#1]

Monthly accounts are produced in monthly excel spreadsheets, e.g. Jan 2012.xlsx, Feb 2012.xlsx etc.

I need to load these into a single QVD file as new monthly spreadsheets become available so that data for each month is accumulated in the QVD The spreadsheets don't a field that would indicate whether records have been deleted, amended etc.

If anyone can offer any advice I'd really appreciate it.

Tony

[jagannalla]

Set vDataPath=D:\QlikView_Data;

Table:

LOAD *,

   *

FROM

$(vDataPath)*.txt

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

STORE Table into Table.qvd;

hope it helps you..

[#3]

Thanks for the reply.

I can't test just now but will later.

When I store say Feb.xlsx into a QVD, will that not overwrite the Jan. data in the QVD?

Thanks

Tony