Bulk import of excel data into sql and GUID issue

Bulk import of excel data into sql and GUID issue

There is an application that users use to capture data. For each record a
uniqueidentifier is created and added to a row(GUID).
There is a requirement to bulk upload by passing the application. Data is
stored in excel. I am using the Microsoft.Jet.OLEDB.4.0 to select the data
from Excel and doing C# SqlBulkCopy tyo insert the values.
Issue is setting the rowduid column to a new GUID for each record. How can
i achieve this. I thought by doing something like a "Select *, newguid as
ID FROM [sheet1$]" but i dont know if there is such a query in excel.
Please help. Thanks.