On Feb 27, 2:07 pm, "Nigel" wrote:
Cos the source is SSRS not Excel !!

I thought the OP said they had control over how data was written - row-
at-a-time.

I don't know anyting about SSRS but if SSRS gives him access to an
Excel WorkSheet then he should be able to write the data all at once -
like I showed him.