it still did not like that, pretty sure that was one of the original that I tried :)
finally got it working with the replace function
CurrentDb.Execute "INSERT INTO [tempITAM]([iTamNumber], [lblLastResolvedDate], [lblClosedDate], [txtDescription], [txtDetailedDescription], [txtWorkLog]...