archiving the file is not in my scope...the file is being generated by the third party vendor on a daily basis...im just accessing their back up csv files to feed data for my database.

Is there by anyways to read the data from CSV file for current year or last 30 days or so...instead reading everything and using the split?

thanks