analyze it with microsoft office excel

[Guest]

I am working in Access 2003. I want to use the 'analyze it with microsoft
office excel' instead of creating an RTF. Sending the report to an RTF works
fine. When I select ''analyze it with microsoft office excel', Excel 2003
opens, the tab is named properly; but there is no data in the worksheet. Any
ideas?

 

[Guest]

Hi,

I usually create a report of the information I want and set it up in the
order I want to see it. After, I run the report and if it looks correct, I
click on the analyze it with excel and it dumps it into a spreadsheet with no
problem. I have done this on several occassions and works every time. If you
do not have a report created, I am not sure if it will work or if you can do
it that way, I'm sure how.

Hope this helps!!