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.
Use the numerical equivalent "Log10(a) = Log(a) / Log(10) "
Import the text file to local storage and query from there. Then any function that mySQL supports (including LOG10() can be used.