Import data from Excel to Word

[Robbo]

Hi,
In office 2003 or 2007, is there an easy way to import data from excel into
a word document in a formatted field/document.

Ie, I want to link specific parts of a word document to an excel worksheet.
I know about going via custom XML in office 2007 using content controls, is
there another way to do it without having to export the excel to XML, then
import the XML into word?

Thanks

 

[Peter Jamieson]

The main "old" ways of including data from and external Excel sheet are:
a. OLE Linking (Edit/Copy the data in Excel, then Edit|Paste Special and
Paste Link in Word. You can change the source to be a named range or a range
in RaCa:RzCz format AFAICR)
b. Use a DATABASE field (e.g. enable the database toolbar in Word) to
insert the data and format it with one of the built-in table formats
c. set up the Word document to be a Mail Merge Main document and connect to
the Excel data source and insert he fields you need where you need them. In
essence you connect to a single row at a time and would need to do more in
code to "fix" the results

I don't know if any of these methods meet your needs but the main problem
iwith all of them is that, even when you get them to work, you have little
control over the formatting of the inserted data and distributing a
Word/Excel solution is non-trivial.