I do this pretty regularly via automation with relatively large amounts of text (for Excel) in a cell. The data type in SQL I use is text. Maybe there are some odd control characters in the data you are trying to grab?
At what point do you get the buffer size error? Andy Davies wrote: > Hi, we used to hear a lot about people migrating to SQL Server 'cos they'd > hit Fox's 2Gb limit - I've just hit a much lower limit in SQL: > > A user for a system I'm prototyping has set up a lot of data in Excel - I > have tried everything to import this to SQL without success: > I keep getting a "data has exceeded buffer size" error. The trouble is > that the user has 'cut and paste'd huge chunks of data into some Excel > cells (well over the agreed design limits but I was hoping to trim it > later). I tried setting the target table columns to 4095 or 8000 but then I > get warnings that I will likely exceed the maximum rowsize of 8000 (doesn't > seem very big! - just 4 x 2kb fields) > So in desperation I tried setting the target table columns to 'text' - same > problem. > I can sidestep the problem by using Excel to convert to .csv or dBaseIII > but this limits all columns to 257 (?) > > How do other people handle large text items in SQL Server? > > Andrew Davies MBCS CITP > - AndyD 8-)# -- Richard Kaye Vice President Artfact/RFC Systems Voice: 617.219.1038 Fax: 617.219.1001 For the fastest response time, please send your support queries to: Technical Support - [EMAIL PROTECTED] Australian Support - [EMAIL PROTECTED] Internet Support - [EMAIL PROTECTED] All Other Requests - [EMAIL PROTECTED] --------------------------------------------------------- This message has been checked for viruses before sending. --------------------------------------------------------- _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.