[AccessD] Export to Excel

Mark,
 
Instead of trying to export the report, export the report's record
source.

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: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/f5fc7423/attachment-0002.html>