I need insert into database from Excel Values(with different headers from excel i.e like spacing and different table structure in database)
Welcome to Forums
Using Read Range activity - You can get the Datatable output
Using Connect activity you can connect to the database your required
Use For Each row of the Datatable you got from the Excel, Make variables according to the column names
Use Execute nonquery activity you can execute INSERT query
Hope this helps
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.