And if not, what is the closest work around.
I have a VBA macro that outputs c.10m rows. I can't output to and Excel table due to the row limit. Ideally I'd like to turn a VBA array directly into a PowerPivot table (or even better overwrite an existing one so that relationships etc would be maintained.)
Failing that I'm thinking of writing to csv and then importing, but it seems like a wasted step.
I have a VBA macro that outputs c.10m rows. I can't output to and Excel table due to the row limit. Ideally I'd like to turn a VBA array directly into a PowerPivot table (or even better overwrite an existing one so that relationships etc would be maintained.)
Failing that I'm thinking of writing to csv and then importing, but it seems like a wasted step.