Good.
Let's start from the MAXIMUM requirement. Most convenient for me.
We can downgrade it later, so do not be afraid, OK?
Here I published the format which I use to upload to the database. I convert all data to this format, there is no other way as all highlighted fields are needed to index database properly.
If you stick with the format, all rows in the file will be unique and you can have all your archive in one file. Also I can just append all files together and upload as one batch.
TEXT file created using any delimited export of the formatted file from EXCEL-like program will be OK.
----
now about text files, let me guess...
Most probably you have text files in form ( Event name, Club name, Date - in the name of the file)
Yellow (1.3 km, 100m, 10 crls)
1 Person Name time
2 Person name time
Blue
1 Person Name time
2 Person name time
This file is easily convertible into my format by putting data into excel or similar program and copying date, course name, event name etc many times. If you do not do it, I have to do it.
Bigger problem is Names, where it is not always clear what is first name and what is last (or Surname as I was taught :)
This part is much easier for you than for me..
Second big problem is time if it is not in real format - excel cleverly identifies it as time/date, and it becomes 12am, or sometimes 12 am next day or whatever: inpredictable...
I know how to deal with it but will try to explain personally if needed. It is specific in each case.