Have the following code I am working with.
It should take the two tables "NEXT_FT" and "THIS_FY", union them together and push that data into a table called schedule.
Any help would be great.
Private Sub Command2_Click()
'UNIONS NEXT AND THIS FY CLASS DATA INTO SCHEDULE'
Dim mySLC As String
mySLC = "SELECT * INTO SCHEDULE" & _
" FROM THIS_FY" & _
" UNION" & _
" SELECT *" & _
" FROM NEXT_FY"