how to open query in excel?

  • Thread starter Thread starter Danny
  • Start date Start date
D

Danny

HI

Is there any way to open a query in excel. For example,
if a user clicks a button to open a query from a main
form, is there anyway I can open the query in excel?

Thank you
 
Is this an Access Query, or an Excel Query?
Ok, to be honest, I don't know if Excel even has queries, so just elaborate
more on your desire.

But, long story short... You can do most anything to Excel from Access by
using VBA.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
If you just want to copy the records to excel then:

1. Ctrl A (select all)
2. Open your excel doc
3. Ctrl V (paste)

Alternatively, you can create a query in Excel using MS Query ( Data | Get
External Data... )

Depends what you want to achieve...

P
 
Back
Top