How to insert active rows from excel to SQL

vinexcel

New member
Joined
Feb 24, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2016
Hi All,

I am working on a template to insert the data from excel to SQL Server.
Based on the Frequency Excel sheet will hide the column. example . When i select frequency 6 then only 6 rows will be available in the sheet and other rows will be hidden.
when i am updating the column all the rows in the sheet got inserted in the DB.

My requirement is to insert only 6 rows.

Please let me know the solution.
Thanks in advance.
 
Back
Top