Insert Excel Worksheets into Word Document

[Barb Reinhardt]

I have an Excel 2003 Workbook with 8 or 10 individual worksheets in it.
I'd like to put the information on the individual worksheets into a Word
2003 Document. I've tried

Insert - Object - Create from File

and I now have two specific questions:

1) The word document only accesses the first worksheet. How do I insert
the other worksheets in the file?
2) The worksheets are generally more than one page long. How do I insert
them so that they break the page in Word?

Around here, they all prefer Word for everything. I find Excel to be much
easier to use when editing tabular documents.

Thanks in advance,
Barb Reinhardt

 

[Barb Reinhardt]

OK, I just tried copying and pasting the Excel info into Word and I got the
entire table. I would like to have the Word document automatically update
if the Excel Document is changed. Can this be done?