RE:

[Gary Lehman <Gary_Lehman@xxxxxxxxxxxxxx>]

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

Gary Lehman
Programmer Analyst
Missouri Consolidated Health Care Plan

                -----Original Message-----
                From:   Jeff Carey [mailto:jeffreycarey@usa.net]
                Sent:   Sunday, June 28, 1998 5:25 AM
                To:     MIDRANGE-L@midrange.com
                Subject:        Re: 

                Could it be you are trying to access a file without a unique
key?  I know the MS
                jet Engine doesn't like that.

                Gary Lehman wrote:

                > Hello,
                >
                > I was wondering if anyone knew anything about the Client
Access 32 bit ODBC
                > driver.  I can get it to work in Access but when I try to
use it in Excel
                > I'm getting an SQL0104 error - Token * was not valid.
Valid tokens:
                > <IDENTIFIER>.  The help just says there is something wrong
with the driver,
                > but it's the most up to date driver that I know of.  Does
anyone have any
                > suggestions?
                >
                > Gary Lehman
                > Programmer Analyst
                > Missouri Consolidated Health Care Plan
                > +---
                > | 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
                > +---



                +---
                | 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
                +---
+---
| 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
+---