[Zope] SQL to Excel

[Bruce Dykes]

----- Original Message -----
From: "Thomas B. Passin" <tpassin@mitretek.org>
To: <zope@zope.org>
Sent: Thursday, May 02, 2002 11:24
Subject: Re: [Zope] SQL to Excel



> I just tried in using your syntax.  It worked fine.  By that, I mean that
> the Test tab of the connection page returned a reasonable-looking result
> when I typed
>
> select * from [land$]
>
> into the query box (here, "land" is the name of the worksheet).
>
> I am using Zope 2.3.3 on Win2000.
>
> Maybe you better say what you mean by "[doesn't] seem to work".

I was getting SQL syntax errors, but my personal entropy field seems to have
abated, and it's working fine now. One possible difference is that I was
using the test tab of the ODBC connection page instead of testing from the Z
SQL method.

thanks to all who replied.

bkd