Scenario Help

[abhaysingh]

Hey Guys,

I have Data source in Excel Form, which is placed at FTP.. Now on daily basis these excel reports are updating..

Scenario1- Some times Whole 2 year data is Replaced

Scenario2- Out of two Year only one year data is replaced.

Scenario3 - Out of two year only 3 month Data is replaced.

In All three Scenario new Data will Append into Excel.

In Scenario1 - I only required to Reload my application and all data will come..

But in Scenario 2 and Scenario 3 How i can do automated Data reload??

Thanks in Advance

Abhay

[Peter_Cammaert]

Just load everything. An Excel data source (especially when talking about a single file) on average doesn't carry >1 million records. Moreover, reading files is less costly than reading through a network pipe.

Did you time your script as it is reading the entire file? Does it take more than 5-10 minutes?

Peter