Excel and queries

Posted by Sarj on July 10, 2001 2:38 AM

How can I run an Access query from Excel and have the data from this in excel format?

Posted by Dax on July 10, 2001 4:59 AM

You can get queries from Access by using the Data, Get External Data, Create New Query. Create a new data source (your database). You will then be able to import any query or table into Excel and also have it refresh whenever you need.

HTH,
Dax