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