VBA, Excel and SQL

[scubadiver]

A) I have a list of postcodes (like zip codes) in Excel

B) I have demographic data in SQL server consisting of almost 2million rows.

What I need - To match the postcodes in Excel with the information in the SQL table.

How can it be done in VBA?

thanks

[xld]

Create a table using SQL, populate it with you zip codes, then do a JOINed lookup of the SQL data.

[scubadiver]

Maybe I message wasn't clear enough. I want to retrieve the matched records in Excel, not in SQL.

[xld]

I understood that, but you need the SQL to get data from an SQL table.