> 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