Les,
Have you tried copying the cell and doing a "Paste Special>Values"?
Sometimes, with a cell that's been worked alot Excel stores all sorts
of weird stuff in there. I've run into this before on files that
were unusually large for what they contained. Doing a Select
All>Copy>Paste Special>Values fixed it.
That is if you're transferring from an .xls file and not a .csv.
HTH,
Jon
On Jan 16, 2007, at 7:36 PM, Les Mizzell wrote:
> 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:266725
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4