Insert Data from Excel to SQL Database?

Question

Hi Experts,
I have export excel data into SQL Database.
But I have one problem, In my Excel sheet there is one dropdownlist and
I have to stored this drop down selected value stored in database.
If only text data are insert perfectly but drop down data are not stored.
Please Help me,

Suthish Nair · Answer

excelSheets = excelWorkBook.Sheets("Sheet1") excelSheets.Activate() excelSheets.Shapes.Item(1).ControlFormat.List
Like this way you can find the different shapes (controls). Put a break point and check the values..