Code:
sqlstr = "INSERT INTO [Ticket Master]([EDI Ref],[Booking Office],[Date Received],[Time Received],[Processed by],[Date Completed],[Time Completed],[Booking Number],[Date Started],[Time Started],[Request Status],Query_Type2,Query_MSG2,[Query_Start-2],[Query_End-2],Query_Type3,Query_MSG3,[Query_Start-3],[Query_End-3],Query_Type4,Query_MSG4,[Query_Start-4],[Query_End-4],Query_Type5,Query_MSG5,[Query_Start-5],[Query_End-5],Request_Source,Amendment_Type,ReStart_1,ReStart_2,ReStart_3,ReStart_4) SELECT [EDI Ref],[Booking Office],[Date Received],[Time Received],[Processed by],[Date Completed],[Time Completed],[Booking Number],[Date Started],[Time Started],[Request Status],Query_Type2,Query_MSG2,[Query_Start-2],[Query_End-2],Query_Type3,Query_MSG3,[Query_Start-3],[Query_End-3],Query_Type4,Query_MSG4,[Query_Start-4],[Query_End-4],Query_Type5,Query_MSG5,[Query_Start-5],[Query_End-5],Request_Source,Amendment_Type,ReStart_1,ReStart_2,ReStart_3,ReStart_4 FROM [Ticket Master_CR]);"