R
Randy
How can I extract a report from access. I want to put the
report into a word or excel file?
report into a word or excel file?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Cheryl Fischer
Open your report in Preview mode. Then, look at the toolbar for the Office
Links icon. This icon offers two options: "Publish it with Microsoft Word"
and "Analyze it with Microsoft Excel".
Links icon. This icon offers two options: "Publish it with Microsoft Word"
and "Analyze it with Microsoft Excel".
G
Guest
I lose the charts associated with the data, using both
word and excel options.
word and excel options.
C
Cheryl Fischer
The two suggested options were not meant to provide or duplicate all of the
functionality of Word or Excel. In fact, when you use the Publish it with
Word option, notice that the report is exported to an RTF file not a DOC.
Does the report need to be editable by others after it is created? Or, do
you want to export the report so that others who do not have Access
installed can read it? If the answer to this last question is 'Yes', then
perhaps an export to PDF will work for you. PDF drivers are relatively
inexpensive (a Google search will list many possibilities), and the Adobe
Acrobat Reader is free and easily downloadable.
If you will provide the forum with more detail about why you want to create
your Reports/Charts in Access and export them to another application,
perhaps someone will have a solution for you.
functionality of Word or Excel. In fact, when you use the Publish it with
Word option, notice that the report is exported to an RTF file not a DOC.
Does the report need to be editable by others after it is created? Or, do
you want to export the report so that others who do not have Access
installed can read it? If the answer to this last question is 'Yes', then
perhaps an export to PDF will work for you. PDF drivers are relatively
inexpensive (a Google search will list many possibilities), and the Adobe
Acrobat Reader is free and easily downloadable.
If you will provide the forum with more detail about why you want to create
your Reports/Charts in Access and export them to another application,
perhaps someone will have a solution for you.
T
Terry
Just a question out of interest...Would snapshot (.snp)
retain the charts? I have had success with snapshot, but
have not used it with charts.
Thanks.
Terry
retain the charts? I have had success with snapshot, but
have not used it with charts.
Thanks.
Terry