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
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