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:184368 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
