Export access pivot table to excel

[the provider]

Hi,

Does anyone know how to export a pivot table to Ms Excel without using the specific button in the Pivot Table View of the form?

Thanks for the help

 

[The_Doc_Man]

1. Don't double post, please.

2. A pivot table is an MS Excel concept. You want a Cross-Tab query.

Regardless of how you generate it, once the query exists, you simple export the query to a spreadsheet the same way you would export anything else to a spreadsheet from access.

Saying "without using the xyz button" can be taken in two ways:

a. You are looking for a programmatic way to do this

b. You don't understand that the only way to get a "pivot table" to Excel from Access is to build a cross-tab table. You cannot avoid using that type of query in Access. There is no other way to get there except to "roll your own" VBA code to re-invent the wheel.

 

[the provider]

Exporting a "cross-tab query" to excel

Thanks for the reply.
I am already using the cross-tab query to get the pivot table as in ms excel. I´d like to recreate the action of the export to excel button so that an excel file could be created (exported from the query) in the pivot table view form. I would like this action to be done as if in a macro.
Can you help me with this?

Thank you

provider

 

[the provider]

the_Doc_man

Hi, and if you could tell if there is a way to allow to add an atachment, which would be stored ina a table field, like an image or spreadsheet, once a form is open and running and be very grateful

thank you

 

[The_Doc_Man]

Unfortunately, the only way I know to create the cross-tab is through a wizard, which doesn't work well with a macro. But I guess you could generate one and then open the query in SQL view. That would let you see what the text looks like so that you could try to build it through VBA. I would consider this to be a formidable task for an Access beginner but it is the only way I know to make it run from a macro.

If I understand your second post (about including something in a table), please look up the Help topic of OLE - Object Linking and Embedding.

However, be aware that OLE has pitfalls. If the object being linked or embedded is big enough, you really want to LINK rather than EMBED because of database size limits.

 

[the provider]

cross-tab query

Thanks for the quick reply.
i´m learning with the help topics. i´ve created some apps but they are very simple. my purpose with be to facilitate the users to atach a picture to a field in a form to be stored in the table. that with be very helpful in the day to day work.
thanks for all the help