I have a macro that pulls data from an extranal websit.

The values return look like this

861
913
315
407
570

These are area code

Based off the value I need to query our database via ODBC
Select Count(*) from Table where Telephone is like value in A1
Select Count(*) from Table where Telephone is like value in A2
Select Count(*) from Table where Telephone is like value in A3
Select Count(*) from Table where Telephone is like value in A4
etc

I only need to see the count return to Column B

Any ideas on how to proceed

Thanks
Steve