>>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.
----------------------------------
António Tavares Lopes