From my experience, it will continue to be a problem intermittently.
For large collection, use oledb, instead of Excel VBO.
Oledb again may not work if the rows*columns are high in number.
In that scenario, try reading in chunks and then merge the collection