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.
RELATED STUFF
- Using Access to Combine Multiple Excel Files: Method 1
- Sending Data to Excel using Access SQL
- Using Access to Combine Multiple Excel Files: Method 2
- Passing Multiple Values to One Parameter
- Sending Variable Access Data To An Excel Range
- Running an Access Parameter Query from Excel
- Documenting Access Queries in Excel
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.
What if the query has more than 65000 lines? It doesn’t give you the option to uncheck the export with formatting option.