Excel VBA Connect SQL Server Using Adodb Activex Object

[@prashantsinha123us]

Thanks. But how to get with Column Header Name

[@itkasana]

it didnt work for me, got debug in set rs=conn.execute("select * from......) please help

[@HarithaComputersTechnology]

Will work ! please check the code