One Star

import master detail from excel into sql tables with GUID id

Hello,
I want to import from excel into an SQL table something like this:
master table Student (IDStudent as GUID, Name)
detail table Grade (IDGrade as GUID, IDStudent as GUID, Grade)
How can I obtain the IDStudent from the master table for inserting into the detail table? I read about the same thing, but that example had the ids autoincrement and with the lastinsertid was not a problem for importing.
Any suggestions would be very appreciated!
Thanks!
1 REPLY
One Star

Re: import master detail from excel into sql tables with GUID id