<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/jp/ui/ContentDefault.master" Inherits="BasePage" Title="" %> <%@ Register Assembly="RSSBus.Engine" Namespace="RSSBus" TagPrefix="cc1" %> Troubleshooting Column Size Restrictions in Microsoft Query
詳しくはこちら
 

Troubleshooting Column Size Restrictions in Microsoft Query

Microsoft Query limits the total size of all columns selected. When all columns are selected, this may result in an error. The solution is to set the Maximum Column Size property.

公開日: 9/15/2014    最終更新日: 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.


本記事に関するご意見、ご質問は弊社サポートチーム support@cdata.co.jp までご連絡ください。