I ran into this last year, but I forgot the exact cure. Try changing your ntext field to a varchar large enough to hold your text. Then, once imported, change the varchar back to ntext.
If that doesn't work, save the spreadsheet as a delimited text file and then import that. I believe the problem, that I had, was that there were too many "long" text fields in my table and SQL would throw the error about the record length. M!ke -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 16, 2007 6:36 PM To: CF-Talk Subject: OT: SQL Server Import Help Needed Trying to import an Excel Spreadsheet into an ntext(16) field using the Enterprise manager. Getting an error: "Row Number 22" Data Source Column is too large for specified buffer size." Looking at the Excel Sheet - it's less than a paragraph of text. Going through my CF Admin form to add data to the same table - I can paste PAGES of stuff from Word into the same column with no problem. I'm sorta stumped. What could it be? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266721 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
