Unless something has chnaged in the SP1 release of Office 2007, none of the
available methods lets you see more than 255 columns. When I tested here,
the DDE method was actually worse than it has been in previous versions.
When I raised the issue, the problem was described as a "Product
Limitation", which I think means that no-one is ever going to attempt to
overcome it, but I'm not completely sure about that.
If that is still true, your only option is to export to a delimited text
file and see if Word can connect to that Word has a converter that may still
be able to read more than 255 columns. /But/ Word can also have difficulties
connecting to such data sources.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"dBNovice" wrote in message
...
I am using Word 2007 that I am trying to merge in more than 256 data
fields from an excel 2007 file. But it seems Word is only seeing the
1st 255 data fields in excel. Is there a way to get past this so I
only need 1 word document that can merge all of the excel fields.