Insert Into syntax error help

[Coleman984]

I get a syntax error message everytime I try this code. Any idea why?

cDB = currentdb.Name


  strSql = "INSERT INTO tblEmployeeAttendance_archive (pkEmpAttID, fkEmployeeID, dteAttendance,fkAttendanceTypeID) " & _
    "IN " & cDB & _
    "SELECT pkEmpAttID, fkEmployeeID, dteAttendance, fkAttendanceTypeID FROM tblEmployeeAttendance WHERE (dteAttendance <= #" & DateMin1Yr & "#);"

 

[jdraw]

You need a space in front of SELECT.