Unable to insert data into SQL table from the data frame

General
1

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)'''

2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.