Hi, I'm receiving the following error when attempting to import an .xls file.
[ODBC Excel Driver] The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. I've read that the data type is chosen by the ODBC driver based on the first 8 records and it appears this may be creating the problem. This Excel workbook has 7 sheets, I've moved the longest columns of each to column B thinking this would solve the problem but hasn't. I'm using cffile for the upload then running cfquery on it to get the results. This application has worked in the past but I have two spreadsheets that are causing an identical problem. Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315783 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4