Okay, now that's fixed, I'm getting the error I initially expected:
Error Type: KeyError Error Value: Company_Name
This doesn't surprise me, as the Browse tab on the ODBC connector comes up empty, and this being an Excel spreadsheet, not a database table proper, there are no field names specifically assigned to the data.
Now, where should the field names be declared/assigned?
The best way would be to insert a new first row in your excel-sheet with the field names you want. Or: use the names which are shown when you test your ZSQL method.
And as a more general question, in the ODBC connector docs, it says that
not
all databases support browsing...what is the specific limitation? I've been able to browse both Access and FoxPro databases, and I find it an invaluable tool. The Excels spreadsheet is the first thing that's ever come up blank for me, and that's kind of an odd duck anyway...
If you really want to use the Browse tab, you have to use named ranges in your excel sheet (look in your excel manual how to name ranges); then you will see the named ranges just like 'normal' tables in a database. (and you can also do something like "select * from nameOfRange " as ZSQL method ...) chris