Which version of Word are you using?

If it is Word 97 or 2000, check the "Select Method" box in the "Open Dtaa
Source" dialog box, then select your file and proceed. You should see an
additional dialog box in which you can select the ODBC method to connect to
the file. Then, when you see a Select Table dialog, try to ensure that the
file you selected  is the name displayed next to "Workbook", then click the
options button and check all the boxes. You should see all the worksheets
and named ranges listed.

If it's Word 2002 or 2003, something is probably going wrong unless you are
already explicitly selecting the old DDE method to connect, because Word
should let you select any sheet using any of the other methods. But to do
the same in Word 2002/2003, check Word Tools|Options|General|Confirm
conversions at open, then go through the connection process again and try
either OLE DB or ODBC.

For further info on these methods, see http://tips.pjmsn.me.uk/t0003b.htm

Peter Jamieson