More on Excel to mysql

Hi,

so...i`m still learning and probably have undertaken a large and laborious idea, but I want to recreate box scores from NBA games but in a slightly different format that is availalable online.

I`ve got it down to a `quick` conversion from the web version to the excel version (each takes less than 3 minutes to convert) and the answers today were helpful, but I have a few more questions.

Is there a way to load into mysql either using my sql or php and setting all the foreign keys to the same field...or do i have to have the foreign key designation already in the excel spread sheet.

Line Scores from box score will have multiple foreign key relationships, to `players`, to `games`...so it`s kind of imoprtant to know here to me...thanks in advance