how about this, bud:
Code:
"UPDATE tblExportExcel SET [EmployeeName] = '" & strEmplName & "',
[CurrStatus] = '" & strCurrStatus & "',
[CurrPosition] = '" & strCurrPosition & "', [CurrLocation] = '" &
strCurrLocation & "', [SelBeginDate] = #" & dtSelBeginDate & "#,
[SelEndDate] = #" & dtSelEndDate & "#, [HSLCExcptPct] = " &
dblHSLCExceptPct & ", [HSLCNumExceptions] = " & lngHSLCNumExceptions & ",
[HSLCAvgHrs] = " & dblHSLCAvgHrs & ", [HSLCLastException] = #" &
dtHSLCLastExcept & "#, [HSLCCity] = '" & strHSLCCity & "',
[HSLCState] = '" & strHSLCState & "', [HSLCRegion] = " &
lngHSLCRegion & ", [HSLCDistrict] = " & lngHSLCDistrict & ",
[HSLCDistrictManager] = '" & strHSLCDistrictMgr & "', [HSLCPhone] = '"
& strHSLCDistPhone & "'
WHERE [EmployeeID] = " & lngEmplID & ";"
[/QUOTE]
does it work?? if it doesn't sir, print it out and look at the result. such as:
Code:
mySQL = statement
debug.print mySQL
did you remember to do that first?? Check your quote usage too. For instance, REGION is being treated like a number. are you sure that's right?? if that particular portion is a string, it'll error.