Data Type Relation Between SQL/ASP And Access

I am trying to insert data from one table to another but it always errors me on type mis matches or parameters.

Basically the SQL statement looks like this:

sql6 = "Insert Into tblWeeklyFixtures_Div3 Select * From tblAllFixtures_div3 Where GameDate > date() <=date()+7"
conn.execute(sql6)

and it gives me error:

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/DIGFootball/Admin/FriDiv3/update2.asp, line 142]

I tihnk it has to be that i havent declared that i will be importing into a Date/Time field in access but when i change this in acess it gives me more errors so for a peacful life i chnaged the field back to text but by doing this the above SQL statement is pretty useless.