Mark Boyd
MarkBoyd at McBeeAssociates.com
Mon Feb 10 09:45:00 CST 2003
Charles - I wish it were that easy. When this whole thing began, I recommended that we send it as a .pdf file. I was told there are some circumstances where the client needs to manipulate the data after they receive it, and they prefer Excel when doing the manipulating. Thanks, Mark -----Original Message----- From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] Sent: Monday, February 10, 2003 10:39 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Export to Excel Mark, If you want to send the report instead of the data, then don't use Excel. Send the report as either .pdf or .snp. Charles Wortz Software Development Division Texas Education Agency 1701 N. Congress Ave Austin, TX 78701-1494 512-463-9493 CWortz at tea.state.tx.us (SELECT * FROM users WHERE clue > 0) -----Original Message----- From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] Sent: Monday 2003 Feb 10 09:34 To: accessd at databaseadvisors.com Subject: RE: [AccessD] Export to Excel The point of this process is to eliminate all user interaction with the formatting of the report. The user clicks a button, which automatically exports the formatted report to Excel. Then, the report is emailed to the appropriate client. How can I only export the record source, without having the user interact with Excel to format the data? Have a pre-designed report template? Mark -----Original Message----- From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] Sent: Monday, February 10, 2003 10:24 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Export to Excel Mark, Instead of trying to export the report, export the report's record source. Charles Wortz -----Original Message----- From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] Sent: Monday 2003 Feb 10 09:18 To: AccessD at databaseadvisors.com Subject: [AccessD] Export to Excel We are having an issue with exporting data from an Access report to an Excel spreadsheet. It seems that whenever there are calculated fields such as report totals, the data doesn't display properly after exporting. Also, some fields are moved way to the right, while others are way left. Does anyone know of 3rd party software that will export an Access report to Excel as clean as possible? Thanks, Mark Boyd Sr. Systems Analyst McBee Associates, Inc. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030210/97180346/attachment-0002.html>