>>Nope, it's not a copy from my code. This is just like. The original statement is a bit longer, but that is what failed. And, I can't give the original statement. We have to simulate it. Alias was skiped in the example for lazyness. The real thing has it.
>>
>>The typo was made once - this is called copy and paste error. :)
>>
>>By SPT you mean to run it as SQLEXEC like
>>

>>?SQLEXEC(m.lnHld,'SELECT Cur1.[Field "C"] AS FieldC FROM myTable AS Cur1')
>>

>>?
>>This ends up the with same problem, was my first try after the CA failed. :(
>
>Strange. I created a table with a [column "C"] as the column, and, did
>
>

?sqlexec(h, 'select dummy.[column "C"] as col_c from dummy', "crsdu")

>
>and it returned col_c without a problem. Without aliasing the field, I was getting colum__c_ (i.e. an underscore for each space and quotation mark). I thought this may be related to "set quoted_identifier on/off", so I tried to set it both ways, still no problem (except the original problem, that they introduced the brackets around the column names so they could have a wizard to migrate all those access/jet databases and thus save access from vanishing when they introduce the smb2 bug...
>
>ODBC driver, then? I got this problemless run with the 11.0 client, didn't try with the older.

Hm, the driver is whatever I found on MS pages. The topmost in google. I do not own a copy of MS Access

I see something similar to you if I SELECT * ... or the FOXPRO result of SQLCOLUMNS. But this is not of much help, since I need to write back.

what is "set quoted_identifier on/off" and where do I set it?