Hi guys, I am new to SQL/database and may not know how to do this well, I am trying to insert a data table which I managed to scrape off SAP. However, I encountered this error when I tried to use the Insert activity from Database package: Insert: Dynamic SQL generation is not supported against a…

@Hou_Paang_Soul Few things to bear in mind The datatable should have data Column names and datatype shpuld exactly match between dataatable and the database table Cheers

Insert DataTable to MS Access

Help Studio

Palaniyappan (Palaniyappan P ) October 2, 2023, 4:09am 2

Check this out for more discussion on this

@Hou_Paang_Soul

Topic		Replies	Views
Error encounter while using 'Insert' activity within database package Help excel , database , activities , error , question	1	1341	November 20, 2019
"Insert: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information." Help database , activities , question	1	2779	December 4, 2019
Insert Into Database gives an error Help	1	2144	April 4, 2019
Facing -Insert: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information Activities database , activities , question	2	310	September 19, 2023
Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information v2 Help studio , error	0	1512	December 10, 2018

Insert DataTable to MS Access

Related topics