Insert Excel values into Database

Help Studio
1

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)

2

@raghuram_katuri

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

Thanks

3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.