Just the other day, I saw someone run an Access Query in Office 2003. Then he selected Office Tools ->Analyze with Excel. This essentially sends the results of the Access query to Excel.
.
This if fine and dandy, but there is a slightly easier way to get the results of an Access query to Excel.
.
You don't have to even open the query . Simply drag the query to the Excel spreadsheet and presto. The query will automatically run and output the results.
.
What about parameter queries you ask? Well, those will run too. Access will ask you for your parameters and the result will shoot over to Excel.
This works for Tables too.
Now that is freakin' sweet. Thanks for the tip, Mike.
Wow I never knew that. It's a simple tip but a huge tame saver.
Will the query refresh when Excel is reopened or is it a static table?
RJ: It's a static table.