How do I insert best quality Access report into Publisher?

I am creating a booklet in Publisher 2003. I have many Access reports that I
want to include as part of the Publisher booklet. I have tried creating a PDF
and selecting and some other methods but the quality is not nearly as good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access reports that I
want to include as part of the Publisher booklet. I have tried creating a PDF
and selecting and some other methods but the quality is not nearly as good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks

Mary,

Thank you. I did exactly as you said it it worked, the print is now much
better. The only problem is the data overflows the text box. I can place in a
table and manipulate, but I would like to not have to do that. Any ideas on
how I can get the Access report to fit format almost exactly like it is in
Access? I know a picture will do the job, but the quality is not there. Your
solution is perfect to get the printing crisp, any ideas to make the job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access reports that I
want to include as part of the Publisher booklet. I have tried creating a PDF
and selecting and some other methods but the quality is not nearly as good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks

Mary, I have 9 columns in the access database that may present a problem.

Thanks,

Mike

"Spinbud" wrote:

Mary,

Thank you. I did exactly as you said it it worked, the print is now much
better. The only problem is the data overflows the text box. I can place in a
table and manipulate, but I would like to not have to do that. Any ideas on
how I can get the Access report to fit format almost exactly like it is in
Access? I know a picture will do the job, but the quality is not there. Your
solution is perfect to get the printing crisp, any ideas to make the job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access reports that I
want to include as part of the Publisher booklet. I have tried creating a PDF
and selecting and some other methods but the quality is not nearly as good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks

There are tricks you can use to span two pages with your table in a booklet
format.
You also can create another text box and link them so the text flows. You also
can use the *continued on page....*(format text box, text box tab).

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
Mary, I have 9 columns in the access database that may present a problem.

Thanks,

Mike

"Spinbud" wrote:

Mary,

Thank you. I did exactly as you said it it worked, the print is now much
better. The only problem is the data overflows the text box. I can place in a
table and manipulate, but I would like to not have to do that. Any ideas on
how I can get the Access report to fit format almost exactly like it is in
Access? I know a picture will do the job, but the quality is not there. Your
solution is perfect to get the printing crisp, any ideas to make the job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access reports that
I
want to include as part of the Publisher booklet. I have tried creating a
PDF
and selecting and some other methods but the quality is not nearly as
good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks

Thanks. I guess I am just lazy. I wish that when you create a PDF and then
simply copy and past that it would print crisply. This way I have the exact
document formatted already. I easily copy and paste a picture but the
crsipness is just not there. The other methods will require formatiing in
Publisher to make it look right. Many thanks for your help.

"Mary Sauer" wrote:

There are tricks you can use to span two pages with your table in a booklet
format.
You also can create another text box and link them so the text flows. You also
can use the *continued on page....*(format text box, text box tab).

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
Mary, I have 9 columns in the access database that may present a problem.

Thanks,

Mike

"Spinbud" wrote:

Mary,

Thank you. I did exactly as you said it it worked, the print is now much
better. The only problem is the data overflows the text box. I can place in a
table and manipulate, but I would like to not have to do that. Any ideas on
how I can get the Access report to fit format almost exactly like it is in
Access? I know a picture will do the job, but the quality is not there. Your
solution is perfect to get the printing crisp, any ideas to make the job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text, click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access reports that
I
want to include as part of the Publisher booklet. I have tried creating a
PDF
and selecting and some other methods but the quality is not nearly as
good
when copied and pasted into Publisher. Any ideas on how to take an Access
report and copy/paste or insert into Publisher where there is very high
quality?
Thanks

If your final product is going to be a .pdf file, why not insert the .pdf
version of the Access report in the .pdf version of the Publisher document?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



"Spinbud" wrote in message
...
Thanks. I guess I am just lazy. I wish that when you create a PDF and then
simply copy and past that it would print crisply. This way I have the
exact
document formatted already. I easily copy and paste a picture but the
crsipness is just not there. The other methods will require formatiing in
Publisher to make it look right. Many thanks for your help.

"Mary Sauer" wrote:

There are tricks you can use to span two pages with your table in a
booklet
format.
You also can create another text box and link them so the text flows. You
also
can use the *continued on page....*(format text box, text box tab).

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
Mary, I have 9 columns in the access database that may present a
problem.

Thanks,

Mike

"Spinbud" wrote:

Mary,

Thank you. I did exactly as you said it it worked, the print is now
much
better. The only problem is the data overflows the text box. I can
place in a
table and manipulate, but I would like to not have to do that. Any
ideas on
how I can get the Access report to fit format almost exactly like it
is in
Access? I know a picture will do the job, but the quality is not
there. Your
solution is perfect to get the printing crisp, any ideas to make the
job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text,
click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access
reports that
I
want to include as part of the Publisher booklet. I have tried
creating a
PDF
and selecting and some other methods but the quality is not nearly
as
good
when copied and pasted into Publisher. Any ideas on how to take an
Access
report and copy/paste or insert into Publisher where there is very
high
quality?
Thanks

That is a very good idea. I was planning to print the report from Publisher
but I could just create a PDF of the Publisher report and then creat numerous
PDF files from Access reports. If I insert one of these Access PDFs as a PDF
in the primary PDF will I be able to have the proper page numbers noted so
the report is seamless?

Many thanks for your help!

Mike

If your final product is going to be a .pdf file, why not insert the .pdf
version of the Access report in the .pdf version of the Publisher document?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



"Spinbud" wrote in message
...
Thanks. I guess I am just lazy. I wish that when you create a PDF and then
simply copy and past that it would print crisply. This way I have the
exact
document formatted already. I easily copy and paste a picture but the
crsipness is just not there. The other methods will require formatiing in
Publisher to make it look right. Many thanks for your help.

"Mary Sauer" wrote:

There are tricks you can use to span two pages with your table in a
booklet
format.
You also can create another text box and link them so the text flows. You
also
can use the *continued on page....*(format text box, text box tab).

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
Mary, I have 9 columns in the access database that may present a
problem.

Thanks,

Mike

"Spinbud" wrote:

Mary,

Thank you. I did exactly as you said it it worked, the print is now
much
better. The only problem is the data overflows the text box. I can
place in a
table and manipulate, but I would like to not have to do that. Any
ideas on
how I can get the Access report to fit format almost exactly like it
is in
Access? I know a picture will do the job, but the quality is not
there. Your
solution is perfect to get the printing crisp, any ideas to make the
job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text,
click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access
reports that
I
want to include as part of the Publisher booklet. I have tried
creating a
PDF
and selecting and some other methods but the quality is not nearly
as
good
when copied and pasted into Publisher. Any ideas on how to take an
Access
report and copy/paste or insert into Publisher where there is very
high
quality?
Thanks

There is a complete help dialogue within Acrobat that will walk you through the
process. Use the keyword combining.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
That is a very good idea. I was planning to print the report from Publisher
but I could just create a PDF of the Publisher report and then creat numerous
PDF files from Access reports. If I insert one of these Access PDFs as a PDF
in the primary PDF will I be able to have the proper page numbers noted so
the report is seamless?

Many thanks for your help!

Mike

If your final product is going to be a .pdf file, why not insert the .pdf
version of the Access report in the .pdf version of the Publisher document?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



"Spinbud" wrote in message
...
Thanks. I guess I am just lazy. I wish that when you create a PDF and then
simply copy and past that it would print crisply. This way I have the
exact
document formatted already. I easily copy and paste a picture but the
crsipness is just not there. The other methods will require formatiing in
Publisher to make it look right. Many thanks for your help.

"Mary Sauer" wrote:

There are tricks you can use to span two pages with your table in a
booklet
format.
You also can create another text box and link them so the text flows. You
also
can use the *continued on page....*(format text box, text box tab).

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
Mary, I have 9 columns in the access database that may present a
problem.

Thanks,

Mike

"Spinbud" wrote:

Mary,

Thank you. I did exactly as you said it it worked, the print is now
much
better. The only problem is the data overflows the text box. I can
place in a
table and manipulate, but I would like to not have to do that. Any
ideas on
how I can get the Access report to fit format almost exactly like it
is in
Access? I know a picture will do the job, but the quality is not
there. Your
solution is perfect to get the printing crisp, any ideas to make the
job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text,
click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access
reports that
I
want to include as part of the Publisher booklet. I have tried
creating a
PDF
and selecting and some other methods but the quality is not nearly
as
good
when copied and pasted into Publisher. Any ideas on how to take an
Access
report and copy/paste or insert into Publisher where there is very
high
quality?
Thanks

Thank you. I cannot believe how helpful everyone is. Unfortunately, I will
not be creating a PDF since I am merging in about 100 company names into the
Publisher document.

I have tried the 'Universal Document Converter' that creates my Access pages
into a TIFF. This seems to work pretty well. I tried JPEG but it is not as
crisp. This way I just paste it onto the page in Publisher as-as. Do you know
of any other vendor where I can create the TIFF/JPEG/etc. that will be most
clear when inserting into Publisher?

Many, many thanks for your help!

"Mary Sauer" wrote:

There is a complete help dialogue within Acrobat that will walk you through the
process. Use the keyword combining.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
That is a very good idea. I was planning to print the report from Publisher
but I could just create a PDF of the Publisher report and then creat numerous
PDF files from Access reports. If I insert one of these Access PDFs as a PDF
in the primary PDF will I be able to have the proper page numbers noted so
the report is seamless?

Many thanks for your help!

Mike

If your final product is going to be a .pdf file, why not insert the .pdf
version of the Access report in the .pdf version of the Publisher document?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



"Spinbud" wrote in message
...
Thanks. I guess I am just lazy. I wish that when you create a PDF and then
simply copy and past that it would print crisply. This way I have the
exact
document formatted already. I easily copy and paste a picture but the
crsipness is just not there. The other methods will require formatiing in
Publisher to make it look right. Many thanks for your help.

"Mary Sauer" wrote:

There are tricks you can use to span two pages with your table in a
booklet
format.
You also can create another text box and link them so the text flows. You
also
can use the *continued on page....*(format text box, text box tab).

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
Mary, I have 9 columns in the access database that may present a
problem.

Thanks,

Mike

"Spinbud" wrote:

Mary,

Thank you. I did exactly as you said it it worked, the print is now
much
better. The only problem is the data overflows the text box. I can
place in a
table and manipulate, but I would like to not have to do that. Any
ideas on
how I can get the Access report to fit format almost exactly like it
is in
Access? I know a picture will do the job, but the quality is not
there. Your
solution is perfect to get the printing crisp, any ideas to make the
job less
cumbersome when inserting the report?

Many thanks for your help,

Mike

"Mary Sauer" wrote:

Right-click the report in Access, export, save as .rtf or .txt.

In Publisher, create a text box, right-click, click change text,
click text
file, browse to the report.

--
Mary Sauer
http://msauer.mvps.org/

"Spinbud" wrote in message
...
I am creating a booklet in Publisher 2003. I have many Access
reports that
I
want to include as part of the Publisher booklet. I have tried
creating a
PDF
and selecting and some other methods but the quality is not nearly
as
good
when copied and pasted into Publisher. Any ideas on how to take an
Access
report and copy/paste or insert into Publisher where there is very
high
quality?
Thanks