4 GB Limit for Powerpivot text file imports via ACE text data source driver

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive

We have been investigating reports that large text files are not completely imported into Powerpivot. And indeed a thorough investigation showed two unexpected things happening.

1.The text import is cut off at 4 GB 2.Import is shown as successful.

This applies to the SQL Server 2008 R2 and the SQL Server 2012 Powerpivot add-in for excel in both, 32 and 64 bit version.


Tags: load, error


2007-2015 VidasSoft Systems Inc.