Connecting to SQL Server table
 

I have an Excel worksheet which has column with a number of rows
representing accounts. I want to write a VBA macro in where I need to
go get the matching value in SQL Server table using the value in the
excel workbook and write to next column.

Pls. help me code this.

Thanks