Re:

[Dave Shaw <dshaw1@xxxxxxxxxxx>]

-----Original Message-----
From: Gary Lehman <Gary_Lehman@mail.mchcp.org>


>You mean ODBC doesn't work in Excel unless the file is a keyed physical
file
>or a logical file?

That's not true, I have several spreadsheets using data from non-keyed
physical files.  The only time I've seen the "Token ... not valid" message
was once when I had the data source set to use the System naming convention
instead of the SQL naming convention - MS Query generates standard SQL only,
and doesn't understand DB2/400-specific stuff.


Dave Shaw, General Nutrition, Greenville, SC (just down the road from BMW -
Bubba Makes Wheels :)
The opinions expressed may not be my employer's unless I'm sufficiently
persuasive...


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---