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!