Join Excel table and SQL table

[notawahoo]

I have an Excel 2007 Table, named "ACCT_LIST", which is a list of 75 account numbers. I want to use the list to inner join to a SQL Server table, to return some data about those 75 accounts. I am using SQL code embedded in VBA. How do I tell it that ACCT_LIST is an Excel table in my SELECT statement? It wants to go find ACCT_LIST in a SQL Server table.

Thanks in advance!