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 …

[image] pyoon: I am unfortunately not allowed to change the headers @pyoon You have to make the headers to have the same name as in the Database for the Insert Activity to work, also the types should be the same as far as I know. But if you cannot change the headers at all then you may need …

Excel read range to insert into a database

Help Studio

pyoon (Patrick Yoon) July 31, 2020, 5:04pm 2

Another picture for clarity as to what my sequence looks like.

Topic		Replies	Views
Insert Excel values into Database Studio	2	839	July 31, 2020
How to Insert excel data into database Help	5	5617	October 8, 2019
Read data from excel sheet dynamically and push to SQL Help	25	4996	October 23, 2019
Insert header into Data table Studio uiautomation	18	3705	March 10, 2022
Bulk upload to sqlserver from excel - Error in Column Names Help datatable , activities , error	13	1998	May 2, 2020

Excel read range to insert into a database

Related topics