Need help with Syntax Error

[jgelpi16]

I need a fresh set of eyes to look at this code. I've looked at it so many times I think I'm going corss-eyed! I keep getting a general syntax error when I try to run this SQL code. Thanks in advance.

mySQL = "INSERT INTO tblAudit (DOWNLOAD_DT, A$EMPLOYEE_NUMBER, A$FULL_NAME, ASSIGNMENT_STATUS, DATE_OF_HIRE," & _
                    "JOB_NAME, LOCATION, PERSON_TYPE_USAGE, SUPERVISOR_FULL_NAME, THIS_PERIOD_START_DATE, ACTUAL_TERM_DATE," & _
                    "PAY_TYPE, PAY_CHANGE_DATE, PAY_CHANGE_REASON, DATE_IN_JOB, Business_Title) VALUES (#" & vDOWNLOAD_DT & "#, " & vEMPLOYEE_NUMBER & "," & _
                    "'" & vFULL_NAME & "', '" & vASSIGNMENT_STATUS & "', #" & vDATE_OF_HIRE & "#, '" & vJOB_NAME & "', '" & vLocation & "'," & _
                    "'" & vPERSON_TYPE_USAGE & "', '" & vSUPERVISOR_FULL_NAME & "', #" & vTHIS_PERIOD_START_DATE & "#, #" & vACTUAL_TERM_DATE & "#," & _
                    "'" & vPAY_TYPE & "', #" & vPAY_CHANGE_DATE & "#, '" & vPAY_CHANGE_REASON & "', #" & vDATE_IN_JOB & "#, '" & vBusiness_Title & "')"

[weekend00]

it will be much help if you provide the information of syntax error.

[jgelpi16]

I solved it....Put brackets around A$EMPLOYEE_NUMBER AND A$FULL_NAME. Didn't realize SQL didn't like the "$" in field names.