Open Access query in Excel with 'save formatted'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IrishRed - 16 Jan 2008 04:26 GMT

I have a query in access which is doing a group by on one field and a sum on
another field. The query runs fine and I get one ID (group by) and a total
(sum).
I have a macro which will open the result of this query in Excel. When this
runs all of the data (no group by or sum) is being sent to Excel. If I were
to do a file export on the query and click on 'save formatted' then I get
exactly what I want but using the macro to do the export is not allowing me
to 'save formatted' so I am ending up with all of the data in my Excel
spreadsheet. I am wondering if there is a way to export the query results
only to Excel.
Any help you can give would be appreciated. Thanks for your time.

Reply to this Message

Jeanette Cunningham - 16 Jan 2008 09:33 GMT

IrishRed,
here is an idea - I don't know if it will suit your situation.
You can import a query from Access into Excel by starting in Excel.
Open a new worksheet, on the Menu click Data >> Import External Data

>>Import Data

Navigate to the saved query in your access database and follow the prompts
as excel guides you through the process.
If this suits your situation, it is an easy solution without any coding
involved.

Jeanette Cunningham

>I have a query in access which is doing a group by on one field and a sum
>on
[quoted text clipped - 11 lines]
> only to Excel.
> Any help you can give would be appreciated. Thanks for your time.

Reply to this Message

IrishRed - 16 Jan 2008 17:02 GMT

Thank you Jeanette. That was very helpful. I am getting back into Access and
Excel after years of doing other projects that have taken me away from it.

> IrishRed,
> here is an idea - I don't know if it will suit your situation.
[quoted text clipped - 23 lines]
> > only to Excel.
> > Any help you can give would be appreciated. Thanks for your time.

Reply to this Message