By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,852 Members | 955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,852 IT Pros & Developers. It's quick & easy.

Exporting Report to Excel and have it look like a pdf.

P: 19
Access 2000 - I have developed a database that houses patient information. The patient information must be sent in an excel file to another company department. I know how to export my data to Excel where it ends up in individual cells (Rows/Colums, etc). I would like for the report that I am exporting to Excel to transfer like a pdf. file. and be similar to the report generated in the database. Kind of like a snapshot of the report, is this possible? I know that I can export the report into viewfinder, but I don't know how to get that image into Excel. Additionally, I want to avoid a multiple step process such as, generate the report, export into viewfinder, save as pdf. , cut paste into existing excel document. I am working with staff that begin to stumble after step 2. Lastly, my other thought is the following: should I create a form in Excel that matches the form in Access and export the data from access to the linked cells?

I have average Access skills, no visual basic or crystal report writing skills. I am quick and can usually figure things out eventually. I am just really stuck and I am not sure if the solution is sooo easy that I am just overlooking it. All of you have been so helpful in the past and I appreciate any information or guidance you could provide. I'll be looking for the nightlight. Thanks!
Jun 7 '07 #1
Share this Question
Share on Google+
3 Replies


jamjar
P: 50
I don't think you can save your report as Excel and retain any report formatting or design. You could use a pdf print utility to save it as a pdf but I assume you also want the users to be able to manipulate it once they receive it? My guess is you can't do it.

Can't you put the database on a shared network and have the other department access it directly?

James
Jun 7 '07 #2

P: 19
I don't think you can save your report as Excel and retain any report formatting or design. You could use a pdf print utility to save it as a pdf but I assume you also want the users to be able to manipulate it once they receive it? My guess is you can't do it.

Can't you put the database on a shared network and have the other department access it directly?

James
Need to manipulate data:
The data would not need to be manipulated. It just needs to be sent within an excel file due to additional information that is sent in excel. For ease of transitioning a "new" way to process information, I was hoping to have the report go directly into the area where individuals would normally spend type retyping/entering the same patient demographic information on sheet 2 of the workbook. If that makes sense????

Sharing a server:
Copies of the same database would be used by multiple distant locations that don't share a server.

Printing to file:
I thought about the idea of printing the report using acrobat distiller, save and then have the individual cut/paste the picture into the excel worksheet. I face two problems - 1. not all of our locations have distiller and 2. too many steps for the clerk to do.


Lastly, it doesn't have to be the report - it could be just a snapshot of that record in form view even. Actually, that would be easier for the clerk.

Thank you for your assistance and input. I would welcome feedback and/or other work arounds that others have done.
Jun 7 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Look at the DoCmd.OutputTo function

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OutputTo objecttype, objectname, outputformat, outputfile
  2.  
Objecttype can be:
  • acOutputForm
  • acOutputModule
  • acOutputQuery
  • acOutputReport
  • acOutputTable
outputformat can be:
  • acFormatActiveXServer
  • acFormatHTML
  • acFormatIIS
  • acFormatRTF
  • acFormatTXT
  • acFormatXLS
  • acFormatSNP (Snapshot)
Jun 13 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.