Keith Williamson
Kwilliamson at RTKL.com
Thu Nov 30 08:18:58 CST 2006
Thanks, Rocky. Regards, 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 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Beach Access Software Sent: Wednesday, November 29, 2006 10:59 AM To: 'Access Developers discussion and problem solving' Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com