NOV 18,2022 Clarion Live Jim Morgan showed his templates for converting TPS to SQL. They are free with a donation suggested if they save you time.
IIRC it creates a conversion program that reads all the TPS data and writes an SQL script to insert it all. That writes a program to read the TPS files and write the SQL script, so that would be all the TPS data in a text file.. It also writes a script to create the DB. This looked easy to do and very automated. It could be rerun multiple times.
So one option to be to convert all the data to a free SQL like SQL Lite, MS SQL Express, Firebird, etc. That would maintain type information, and deal with dates plus have relationships. It would be something they could open in a DB viewer to see it all.
A second option would be to hack that template to write CSV files.
John Hickey/Jim Morgan - Converting TPS to SQL! NOV 18,2022
Not sure if they still sell it but the TPS OBDC driver would let them read your files directly.