When I run my vb app I get the following error message:

Run Time error ‘3075’

Syntax error (missing operator) in query expression ‘Date1>=#01/01/2999# AND Date2<=#01/31/2000# And City = ‘NY# AND State = ‘New York’


Here is my SQL query:
It takes a snap shot of what is in the db and places it into a temp db the variable is strtempDB


db.Execute "SELECT * INTO Places IN '" & strTempDb & "' FROM Places WHERE Date1>=#" & Format(datFromDate, "mm/dd/yyyy") & "# AND Date2<=#" & Format(datToDate, "mm/dd/yyyy") & "# AND City = '" & (datCity.Text) & "# AND State = '" & (datState.Text) & "'"


Can someone please correct the errr I am encountering:
The problem is either the ' " or the #

Help is appreciated,
Stevie