Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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