Ok..I&#039m trying your wonderful data shaping scripts, but have run into a wall. I&#039m getting an error "The data shape command contains a syntax error at or near position 212 in the command. The command text near the error is: " Internal_Employee_ID TO Internal_Employee_ID)"." I&#039ve looked over your scripts and looked at mine and I can&#039t see the problem. Can you help???<BR><BR>Here&#039s my script:<BR>strShapeSQL = "SHAPE {SELECT First_NM, Middle_NM, Last_NM, Internal_Employee_ID FROM Position_Employee_Current}" & _<BR><BR>"APPEND ({SELECT Internal_Employee_ID, Employment_Status FROM Employee_Position} AS Status" & _<BR><BR>"RELATE Internal_Employee_ID TO Internal_Employee_ID)"<BR>