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,

Answer 1

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..