@jzwp22, @Galaxiom Thanks for the quick reply. I looked into it a little more thoroughly and did each section at a time and was able to get the code to work. The code is below:
strSQL = "INSERT INTO tblGroupRenewal ( PLATFORM_CD, BLK_BUS_CD, GRP_NBR, MSTR_RPT_NBR, GRP_RESET_DT, GRP_TERM_DT ) "...