[AccessD] CSV export

Keith:

I've got a bunch of automation code exporting stuff to Excel if you want a
sample. It's not elegant but it works.

I've also got code where I had to do a bunch of formatting and other things
in a spreadsheet I was creating from Access.  I used the macro recorder in
Excel and just copied out the code it generated into my module.  I can send
you some snips of that as well if you need to make a full on spreadsheet
instead of just a CSV file that will open in Excel.

Best,

Rocky


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

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

-- 
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.15.0/557 - Release Date: 11/29/2006
4:15 PM