Forum Discussion

muttu's avatar
muttu
Occasional Contributor
16 years ago

Requirement to read data from the excel tables with multiple rows.

We are using below functions to read data from excel & store it in dictionary objects as key-value pair. It works for the data in Table1(attached file Table) , we get the resulst as "David" But ...
AlexanderM's avatar
AlexanderM
Icon for Staff rankStaff
16 years ago

Hi Mruttunjay,





You get this error due to an attempt to add a duplicate key.





To prevent it, you can change the line with "Set RecSet..." so that it looks like this:





Set RecSet = AConnection.Execute("SELECT DISTINCT FROM "+ sTableName)