Excel ADODB and SQL Server Table-Valued parameters

[SlipEternal]

I am trying to create a stored procedure that will take all of the data needed. The stored procedure needs to create one record in one table, use that primary key as a foreign key in a record in a second table, then use that primary key as a foreign key for several records in a third table. If I were using C#, I would create a stored procedure with parameters for each individual record, then for the multiple records to be added to the third table, I would use a table-valued parameter. I am creating an ODBC connection to my SQL Server database. Looking through the available datatypes for the parameters, I see Array, but I am not sure how to use that. It might be what I am looking for, but I am having trouble finding information on it. Perhaps my search-fu is weak.

Can anyone point me in the right direction? A link or two would be most appreciated!

[SlipEternal]

Never mind. I just created a stored procedure to create the first two records, then a stored procedure to create each additional record. Then, I loop through the rows to grab the data to add for each additional record.