Import CSV to multiple tables

You can only run an import into one table at a time. You could script multiple imports into multiple tables. Filemaker will create the new tables, and you can delete the fields you don't want.
You would have to create any relationships manually.

I'm not sure you have the optimal structure setup. Does each competitor gets a score in each "round", or do they skip rounds?
Are they playing each other as well? What is the sport we're talking about? What are you actually collecting and what do you hope to track/report on?

It my be that you need tables like this:
Competitor - CompetitorID, name etc ( this may be a small table with few records,or thousands as for the olympics)
event - eventID, date, ground, eventcompetitor1, eventcompetitor2, score1, score2  ( for two teams home & away) or
event - eventID, date, eventname, ground etc
score - ID, eventID, eventcompetitorID, score

Then you would create relationships between the event, competitor and score tables as required.
Then you can run reports by sorting the games by year, quarter or ground or competitor etc

You could do this kind of on the fly by creating global fields as well, and crating relationships you could populate via lists, which would work well for a small project for a single user.

It's hard to give you much more help without knowing more about your project.

Thanks for the direction. The database is keeping track of National Clay target events, so a competitor may not shoot every event. I get sent the results in the form of Competitors name and score for each of the events as the occur through out the year. Ultimately the database will be used to select national teams and possibly some form of performance analysis. A competitor must shoot events A, B & C to qualify for team A and shoot events B, C, D to qualify for team B etc.

Most of the data entry will be done by importing the CSV event records, apart from the odd manual entry.

I hope that gives you enough information to work with.

kraftyman, the table structure (or whatever its called) that you suggest above is very similar to my original plan but, I can't see how to populate the separate tables when I can only import data into one table. Do I need create a separate import table and then somehow distribute the records to the correct places?

lesouef, doing it this way how do I maintain the link between the separate records. eg. my CSV file has no knowledge of the competitor ID, so if scores go into one table and names go into another how do they reference each other? have I misunderstood your suggestion?

you said the csv has a (name, event1, event2, etc.) structure
is the "name" a unique identifier ?
are event1, event2 etc also in a predictable pattern, are the non-attended events included as "null"scores?
eg

if it just looks like
smith, 21, 23, 45,67,,,45,78,,,
wesson,,23,45,,34,,45,67,,,


where the "empty"spaces between commas are null scores and smith & wesson (hee hee..) are unique

If so,  then you are getting a fairly predictable data array that could be parsed by filemaker text functions and each data element distributed to a different field

if the csv is not so well structured, then you may have additional work to do
Can you send a snippet of your csv ?( remove any sensitive data..)

The CSV will only have the competitors name and score for that event. So yes the name is a unique ID for the CSV file and no it won't have any other event data. I am already parsing the event data to create the CSV file so I could add some custom fields if required.
Example attached.
PS. Smith and Wesson are retired shooters, I don't see them around much any more!