That would be my interpretation of the error as well, however the sheet only has 1 column and that column has only 2956 records.
Any other ideas? -- Jay > -----Original Message----- > From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] > Sent: 16 November 2004 12:56 > To: CF-Talk > Subject: Re: ODBC error I can't explain > > James Smith wrote: > > >I am reading an excel file with an ODBC query and I am getting the > >following error. > > > >[Macromedia][SequeLink JDBC Driver][ODBC > Socket][Microsoft][ODBC Excel > >Driver] Too many fields defined. > > > >Can anyone explain this error, I am not sure why I am getting it. > > > > > There is a limit to the number of columns you can have in a query. > Chances are the driver thinks that the query is returning the > maximum number of columns an excel spreadsheet can have, > which I think is some thing like the magic 65535 number. I > think you are looking at a maximum of 256 columns in a query. > > Make sure that you have ranges and columns defined in your > spreadsheet to make sure that there are specific "tables" and > "columns" to query. > > Stephen > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184372 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54