I wouldn't bother. If your excel files contain so much information that you see performance problems when you load all the data then you have bigger problems to worry about anyway. You should then seriously consider storing that much data in a real database.
If this answer doesn't satisfy you then search for and read some discussions on this topic:
Thank You for the reply. Here i have only 100 records in my excel sheet.
What i did was create qvd from current excel sheet. then in the next moth load that sheet and concat with my qvd. the create new qvd with 2 month data and so on.
The problem i have is if someone reload that script twice a month, data will be duplicate. So i want to prvent this.
The easy way out is not to load the qvd, but simply load all the excel files. Or if you do want to use the qvd then move the excel file to another folder after loading it. Or use one of the many other solutions you can find on this site using the search feature.
