Loading with Multiple Excel Sheets

[#1]

Hi,

   I have excel sheet with different name that is like 2013oct3,2013oct4. I have loaded script like given below. Now i am facing the problem is if the excel sheet is wrongly copied by the user. that value is also calculating. how to i calculate the value which is single. if i give distinct Expression as Sum(Distinct Total) . it showing wrong value. Please give me the solution ASP

Load

Filename() as filename,

     Date(date#(mid(Filename(),18,8),'YYYYMMDD'),'DD-MM-YYYY')  as orderdate, .. ..

From /*.CSV.

[#2 · Accepted solution]

Now I am using auto load