Recent content by jlovett

Variable SQL Update String. Hi Bob, The name "Table" was for example reasons only. I appreciate the information, I believe this should do what I need. I dont' think I was getting the syntax quite right. jody

I need help using a string variable in an update statement. A little background: I have a call center application that imports spreadsheets(workorders) from outside contractors. The file that they send back in will be in the following format. 20070709143618Ticket193596.xls (yyyy mm dd hh mm ss)...