reading from SQL

[Texas Tonie]

Hello,

connecting to SQL from Excel, how can I set filters without using a query
format (Excel Services in SharePoint does not accept queries in a workbook).

All help much appreciated.

A despairing Texas Tonie