Hi,

I am using as excel sheet to import data into SQL server using VB App. On Excel sheet, some of the columns are list boxes and have up to 10 items in each of them.

If I have to import just 1- 2 records, Excel recordset iterates number of times the items in the list box so for each record I import into the SQL server I see same record has been inserted 8 items.


Can some one help me to resolve this?