Re: CA400 ODBC error in EXCEL

[Dave Mahadevan <mahadevan@xxxxxxxx>]

Gary:

I used the ODBC in EXCEL to pull data and it worked great.  My suggestion is you
ask for the fields by name.  Or better name the file and then use the prefix as
A.* etc. (I have not tried this)

Gary Lehman wrote:

> I apologize for lack of subject.  Here is the question again:
>
> 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?
>

--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


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