>Strange, but the failure will ONLY FAIL if the field name as " TO " as part of it.. ie:
>
>select "AMT TO REFUND" as MyField from "Table 1" -- FAILS
I created an Access DB and a table with that field name (with a "to" and spaces) and it works for me. It might be something other than the "TO".
What is your error message from the ODBC driver?
Also, do an SQLCOLUMNS(...,"NATIVE") and see if that give you any other information.