Error "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'log10' in expression" when connected to a text file (.csv) (4308037)

The following error occurs when the numerical function LOG10(x) is included in query:

"[Microsoft][ODBC Microsoft Access Driver] Undefined function 'log10' in expression" 

LOG(x) works as expected.

RESOLUTION 1:

Use the numerical equivalent "Log10(a) = Log(a) / Log(10) "

or

RESOLUTION 2:

Import the text file to local storage and query from there. Then any function that mySQL supports (including LOG10() can be used.