Sorry, I misunderstood. That makes sense to do the query straight from excel.

Thanks!

"Bill Manville" wrote:


As I said,
Is there a reason why you can't query the SQL Server 2000 database
directly from Excel? I would think you should be able to, by setting
up an appropriate ODBC connection.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup