I'm trying to insert data into SQL table from the data frame, but could not succeed as I'm getting invalid object error, CLIENT not found.
How to insert data to SQL table from dataframe.
'''sqlstring_adh_loa <- paste("insert into [KG_TEXT].[dbo].[EMPLOYEE] select * from CLIENT where
FISC_YR =",CURRENT_FISC_YR, " and FISC_WK =",CURRENT_FISC_WK)
dbGetQuery(db_conn,sqlstring_adh_loa)'''