The trouble with "the advice" is that none of the methods of connecting to
Excel data (or any other kind of data) can be guaranteed to do what you
need: each has its own limitations, and there are quite a few.
In this case, are you in a position to connect directly to the SQL Server?
If so, that still may not solve the problem, but it may well cut out the
"middle man".
Peter Jamieson
"cheshirecat" wrote in message
news
I've been reading the threads and trying the advice to no avail. When I
merge
into Word 2003 from an Excel spreadsheet that's pulling data off a SQL
Server, two fields are truncated at 255, but a third is not. I've tried
padding the first row, but it doesn't work, nor does chosing the
connection
method. Any ideas?
thanks,
Linda