Does someone have some sample code, or maybe point me to a
resource?

I have an excel spreadsheet, Column A has EmployeeID#'s,
say 500 rows worth. I want to loop thru each EmployeeID in
ColA and query a SQL Server database for LastName,
FirstName, etc. to populate ColB, ColC, etc.

Any help would be extremely appreciated.

Thanks in advance,
ChrisB