[AccessD] CSV export

Keith:

I wouldn't export the report.  I'd probably create a temp table to store the
values and export to an Excel spreadsheet.  You could actually export the
formulas this way if you wanted to.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Keith Williamson
Sent: Wednesday, November 29, 2006 6:18 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] CSV export

Guys, I am probably showing my rustiness now.....   :-).........but how
do I do a VBA export of a report.  I have a report that I need to export
in CSV format, for uploading into another program.  I can't really just
use the query behind the report for the "TransferText" command....as the
report actually calculates some ledger codes, and summaries.  I would
hate to do an excel export, and then convert out of excel.  

 

Any help would be appreciated.

 

By the way........I am sure that I will be much more active on this side
of the lists (rather than OT), as my new job is getting me back into
some coding (at least for the short term).  I also don't have time for
OT at work (just the odd, untimely responses, from home.)

 

:-)

 

Thanks again,

 

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
<http://www.rtkl.com/> 

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.430 / Virus Database: 268.14.19/556 - Release Date: 11/28/2006
3:22 PM