Even with an ODBC driver, TopSpeed is not a full RDBMS. You must understand the translation layer's capabilities.
An ODBC driver is not magic. TopSpeed’s file-server architecture means all filtering happens on the client machine (the ODBC driver’s host). For large files (millions of records), performance can be disappointing. odbc driver for topspeed
(Limited)