>>Hi ALL,
>>
>>I need to read / write to an ACCESS database.
>>
>>I run into follwing:
>>
>>A column is named, as reported by SQLCOLUMNS(...,'Native'), Field "C".
>>
>>How do I adress this in a CA?
>>SELCTCMD is like 'SELECT Table.[Field "C"] FROM Table'
>>I get SQL error 1526
>>Error in expression Table.[Field [C]]
>
>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.


That solves it.

muito obrigado