EnviroInsite Forum

Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: Too Many Fields Defined error


Senior Member

Status: Offline
Posts: 271
Date:
Too Many Fields Defined error
Permalink  
 


When I load my Excel data file in EnviroInsite, I'm getting the following error message:

 

Get Reader

ERROR [HY001][Microsoft][ODBC Excel Driver] Too many fields define. 

at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)



__________________


Senior Member

Status: Offline
Posts: 271
Date:
Permalink  
 

When you see this error it means that the database driver is finding something in your Excel spreadsheet to the right of your actual data columns that's making it think you have more fields defined than you actually intended. Sometimes it can be something innocent like the assignment of Formatting properties to cells where there's no data. The way to fix this problem is to open the spreadsheet in Excel. Then go to each sheet and 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 2007.

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.



Create your own FREE Forum
Report Abuse
Powered by ActiveBoard