Hi,
You can use the External Data feature of Excel:
- menu Data > Import (or Get) External Data > New Database Query
- in the dilaog, choose a data source or data source type
- then follow the dialog steps and build your query
or in VBA you can use ADO:
- Add the Microsoft ActiveX Data Object library throu the Tools >referwences
menu of the VB Editor
I hope this helps,
Sebastien