I am reading a csv file that is being comma separated as shown in the image, I would like to know how to separate the rows and columns and then get all that data and insert into the database
Use Read CSV activity and specify delimiter as “,” in properties and read file and it will give you output as dataTable. Then you insert into data base.
Sorry for the question, I am lazy on this subject, but how do I insert a data table variable into the database? Do I need to do some conversion or just insert the table I want?
Please check below thread: