Hi

I'm not overly-knowledgeable about this, but I use Data / Get External Data
/ New Databse Query (on XL2K)

Hope this helps.

--
Andy.


"Hall" wrote in message
...
I want to populate my spreadsheet with data from an external SQL Server
database. I've setup the ODBC data source as a DSN name and can access
the
database's data with no problem.

My question is how do I run an SQL SELECT statement against that database.
Where can this statement reside?

Thx all