Help on Taking List of ID's from excel column and using in Select database query

Help Activities
, ,
1

HI,

I have bunch of ID’s(ID1,ID2,…ID10) in Excel Column and Successfully added to collections. Now How can i use them to search in my Database Query.

Query - Select * From Dtable where ApptNUM in (list of Strings)

How can i print “List of Strings” in (‘ID1’,‘ID2’,…,‘ID10’)

Can Someone Please help me!