Insert Excel values into Database

Hello Everyone,
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.