Created On:  17 October 2011

Problem:

While running AcuXDBC you get an error message, for example: Too many columns 369 (max:256)

Resolution:

You can increase this limit by modifying the DSN that was created for the AcuXDBC data source. See Chapter 5.8.3 AcuXDBC Setup: Advanced Tab of the AcuXDBC User's Guide for more information:

Here are some limits to be aware of that are imposed by Microsoft:

Excel: Worksheet size 65,536 rows by 256 columns column width 255 characters.

Access: Number of fields in a table 255