Re: [Zope] SQL to Excel

["Bruce Dykes" <bkd@xxxxxxxxxxxx>]

----- Original Message -----
From: "Thomas B. Passin" <tpassin@xxxxxxxxxxxx>
To: <zope@xxxxxxxx>
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



_______________________________________________
Zope maillist  -  Zope@xxxxxxxx
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )