Bulk insert in sql server

If your table is configured correctly, the unique identifier will automatically increment - all you have to do is add the rows.

As to your problem, I would do it this way (psuedo-code follows):

open file
create/open connection
create command object
while you have records
{
    set the cmd parameters with the data you have to insert for the current record
    SqlCommand.ExecuteNonScalar (I would also call a stored proc, but that's up to you)
}
close connection