Microsoft KB Archive/114286

= Invalid Column Number Adding Fields from Table =

Article ID: 114286

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Query 2000

-



This article was previously published under Q114286



SYMPTOMS
In Microsoft Query, if you save a query result set as a Microsoft Access, FoxPro, or dBASE table with an index, when you open the newly created table and add all the fields from the table to the query window, you may receive the following error message:

Invalid column number



CAUSE
Microsoft Query supports up to 256 columns in a table. When you save a table that contains 255 columns as a Microsoft Access, or FoxPro table, and you add an index on a field in the table, the saved table exceeds the 256-column limit, but you do not receive an error message.



WORKAROUND
When you save a query result as a Microsoft Access, or FoxPro table, to avoid receiving the error message above when you use the table, do one of the following:


 * When you save a query that contains 255 fields as a table, do not add an index to the table. -or-


 * Before you save a query as a table, make sure the query window contains fewer than 255 fields. -or-


 * When you open a table that has been saved in Microsoft Query with 255 fields and an index, add only the necessary fields to the query window.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

