If i understand you well...
MS Access database does not supports recurrence in queries. You have to write method as below:
Dim startDate As Date = Date.Today()
Dim endDate As Date = startDate.AddDays(15)
Dim currDate As Date = startDate
Do While (currDate < endDate)
Console.WriteLine("INSERT INTO TableName (StartDate, EndDate) VALUES ({0}, {1})", currDate, endDate)
currDate = currDate.AddDays(1)
Loop
As you can see, i'm using
Do... Loop[
^] statement to loop through the dates.