View Access Reports in Excel

[Jorge]

Hello everyone, I am working on a project for my school
and I need to know how to view data from access reports in
excel. I am using Access 2000 and Excel 2000. If theres a
code or something that I can use to see this info on excel
pls let me know, it will be greatly appreciated.

 

[Frank Kabel]

Hi
you could import the raw data from Access to Excel. See the menu
'Data - Import External Data - Import Data'

 

[JulieD]

Hi Jorge

not sure you can see access "reports" themselves in Excel, but you can link
to an access database via the Data / Get External Data / New Database Query
option.

Let us know how you get on.

Cheers
JulieD

 

[grinning_crow]

You could try:

data/get external data/run database query

the wizard is pretty straightforwar

 

[Jorge]

Thanks for your reply but what I really need is that Excel
ask the user what type of report from the database he
wants to manipulate. For example, if I want to see the
reports of selling progress in excel to make charts and
graphs about it; ir theres something I can use like a
macro in excel that it will ask me what report I want to
see.

 

[JulieD]

Hi Jorge

can't think of an easy way to do this from excel - you would need to create
a macro to bring in the underlying table / query for every report you have
in access

however, it is easy to do if you start out in access - the user can choose
the report he wants, go into print preview of it and then click on Analyse
it with Excel (or whatever the current wording is - this is in Access 2000).

any possiblity of your users starting out in access and then ending up in
excel?

Cheers
julieD

 

[Frank Kabel]

Hi
you could automate Access through Excel's VBA but this is a little bit
more complicated. In your case import the raw data (and not the Access
reports) to Excel and create your charts based on this data