>>>Use back quotes `:
>>>
>>>SQLEXEC(m.lnODBC,'SELECT Cur1.`Field "C"` AS FieldC FROM myTable AS Cur1')
>>>
>>>This is the standard approach for Microsoft ODBC drivers when dealing with column names that contain characters others than simple letters, numbers and underscores.
>>
>>Standard? I saw that only once, in 2006, on MySQL... never on anything Microsoft. I assumed that brackets were used for it, probably because my database experience (not in the microsoftened sense of the word) is 99% TSQL and 1% other.
>
>"Standard approach for Microsoft ODBC drivers" means exactly what it says: it's the way Microsoft ODBC drivers (Excel, Access, dBASE, text, whatever) deal with column names.
Last time I was reading ODBC documentation was about 1994 :).