I’m having trouble extracting data from excel, putting it into a data table and then inserting it into an existing data table on a SQL server. (There is a blacked-out section due to it containing personal information). I have the “AddHeaders” option enabled but not PreserveFormat or UseFilter. The whole process is I am using is simply [Excel Application Scope(Read Range) --> Insert ] with the output for Read Range activity and input for the Insert activity is “table”. Maybe I need to add something else, I’m not entirely sure.
This is the error that it is giving me along with the local value.
It seems that the header is not properly being added due to it having certain words. I am unfortunately not allowed to change the headers so I was wondering if there was a way to somehow get it to work with these headers.