SQL + VBA String

[jgelpi16]

I'm trying to run the below SQL string in VBA. However, when I do I receive a data type mismatch error. I have also tried using #" & dtPayrollMonth & "# for the date variable, but received the same error. I also tried surrounding "Corp" in "", but that didn't work. Thanks in advance.

    mySQL = "INSERT INTO tblPayroll_Data ( PayrollAmt, Trailing12Payroll, Department, PayrollMonth ) " & _
        "SELECT Sum(tblPayroll_Import.[" & arrFields(i) & "]) AS [SumOf" & arrFields(i) & "], Sum(tblPayroll_Import.[Trailing 12 Mos#]) " & _
        "AS [SumOfTrailing 12 Mos#], 'Corp' AS Department, Cdate(" & dtPayrollMonth & ") AS PayrollMonth " & _
        "FROM tblPayroll_Import;"
db.Execute mySQL, dbFailOnError

[Bob Fitz]

When the code breaks, have you checked that dtPayrollMonth is holding a value that can be converted to a date.

[jgelpi16]

Unfortunately the error lied in the table I was importing. I made a stupid assumption that a numeric field was actually formatted as numeric...It was formatted as text. Problem resolved. Thanks for the feedback/input.