Converting .TPS (TopSpeed) to SQL I have an older application that uses TopSpeed as the database engine. I want to use some of the data contained in these tables in another application that uses SQL. To accomplish this, I purchased the TPS ODBC driver and used Access to move the data from the TPS tables to an SQL database by using the linked tables feature.

This works fine, but I'm looking for an automated solution (plus, the Access way is messy). Is there a tool out there that could help?
You don't have to use Access as a mediator.

You can look into SSIS or import utility to import data from .TPS to SQL. You have to select Flat file data source.

At the end of the import utility, you will have the option to save the package and then schedule it using SQL Agent job.

Refer to : How to Migrate Data From Top Speed Database Files

Also, look into SSMA (SQL Server Migration Assistant). I have used it for Sybase to SQL Migration, but not sure if it will be good fit for TopSpeed migration.