how to make table in excel visible for odbc dsn file & connect to

[PW]

I'm trying to make data in excel appear in a word doc (office 2007) as an
invoice. setting up an odc file with the "connect to data source.odc"
folder, I get a message "this data source contains no visible tables". what
am I doing wrong?

 

[Graham Mayor]

Set Word Options > Advanced > General > Confirm file conversion on open.
When you open the data you will be given a list of various opening options.
Click the ODBC option. You will see another dialog listing the file names
and the main window with the tables will probably be empty. Select the
correct data source in the filename window and click 'options'.
Check all the boxes - though System Tables is the one in question. This will
place the tables in the empty top window. Select Sheet1$ and click OK.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>