Exporting Table to comma delimited text file

[Ray S.]

I want to include code to export a Table file to a comma delimited text file
that uses no text qualifier and includes the first row as the field names.
Ideally, I would like to save a copy of that file locally and e-mail a copy
to someone in another department. Can anyone help me with this? Right now I
have to go through the manual selection of Export...then the file type...the
delimiter...text qualifier...and inclusion of field names on first row.

 

[David Lloyd]

Ray:

I believe the TransferText method does what you would like to do. You can
specify whether to include field names, and the export specification can be
set not to use a text qualifier.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I want to include code to export a Table file to a comma delimited text file
that uses no text qualifier and includes the first row as the field names.
Ideally, I would like to save a copy of that file locally and e-mail a copy
to someone in another department. Can anyone help me with this? Right now I
have to go through the manual selection of Export...then the file type...the
delimiter...text qualifier...and inclusion of field names on first row.

 

[Ray S.]

Thanks, I figured out how to use the TransferText function...It works fine.
I'd just like now to automate emailing that file all as part of the same
process.