[AccessD] Export to Excel

I haven't read all the responses as yet, but has anyone suggested using the import function in Excel instead of exporting from Access.

You can set up the Excel sheet with all the proper formatting and using the Data/Get External Data/ etc.  you can grab the information from an Access table or Query.  Then anytime the user wants to update the information on the spreadsheet, they click a button on the toolbar and it's all done.  No need to reformat or anything.

I've done this with several users who prefer to manipulate data within Excel and send it out.  It works very well.

Let me know if you need more info.
>>> MarkBoyd at mcbeeassociates.com 02/10/03 09:34AM >>>

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 
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/20030211/4d1e4cad/attachment-0002.html>