Too Many Fields Defined

<< Click to Display Table of Contents >>

EQuIS 7  >>  EnviroInsite > Frequently Asked Questions > Troubleshooting Error Messages >

Too Many Fields Defined

This error message occurs when using an EI database and not an EQuIS database. This error means that the database driver is finding something in your Microsoft Excel spreadsheet to the right of data columns (i.e., Excel sees more fields defined than you actually intended). Sometimes it can be something innocent like the assignment of formatting properties to cells without data. To fix this problem, open the spreadsheet in Excel and on each worksheet unhide the columns to the right of your data. Next, highlight all the columns to the right of your data columns and select Clear> Clear All. It's in the Home Tab's Editing Panel in MS Excel.