Report - Analyze with Excel

[Elizabeth Reynolds]

We just upgraded to Access 2007. I have reports in there that at times I
need to put into spreadsheet form. To do this before I had the option to
"analyze with Excel" it is not an option that I see anymore. Can anyone tell
me where this is or what I can do?

My database is pulling a lot of information from all kinds of tables so
sometimes there is a need to manipulate this data, to sort or delete data
that I wouldn't want to delete from the datbase.

Thanks for any kind of help you can give me!

 

[krissco]

We just upgraded to Access 2007. I have reports in there that at times I
need to put into spreadsheet form. To do this before I had the option to
"analyze with Excel" it is not an option that I see anymore. Can anyone tell
me where this is or what I can do?

My database is pulling a lot of information from all kinds of tables so
sometimes there is a need to manipulate this data, to sort or delete data
that I wouldn't want to delete from the datbase.

Thanks for any kind of help you can give me!

I don't have A2007, but per Allen Browne, you can still export a query
of your data.
http://www.allenbrowne.com/Access2007.html#Gone

If the results of exporting the query are not desirable, you can
always resort to automating Excel - placing data into it cell-by-cell
through VBA.

-Kris

 

[Elizabeth Reynolds]

That is correct you can export a query or table but in our database it is set
up so you have to go into the design view by holding the shift key down to
access it when opening the database. We don't need all who can enter and
view data to be able to do this so using the export to excel worked
fantastic.

I don't know how to do the automating feature you are speaking of.

Beth

 

[Cris]

You can try changing the report to a form.
You can export a form to Excel.