Query Federation & Custom Schema
Learn about the latest features including in the CData Connect Cloud data connectivity platform.
Date Entered: 9/15/2014 Last Updated: 9/15/2014
In Microsoft Query in Excel, you may not be able to load the entire table or you may receive an "Out of memory error" if you have more than 85 columns. If you have more columns than this, the total column size cannot exceed 22k in Microsoft Query.
One solution is to set the Maximum Column Size property in the connection string. The default value is 16000. The driver will not report columns that have a size larger than this limit.
We appreciate your feedback. If you have any questions, comments, or suggestions about this entry, please contact our support team at email@example.com.