[AccessD] Exporting comma delimited data

John,

Here's an ancient bit from my early ADO days for creating a tab
delimited file with optional fieldnames.  You can probably adapt it, but
don't expect it to be terribly elegant because it was written based on
ADO 2.1 and I was fumbling my way through it. 


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: Tuesday, April 11, 2006 8:22 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Exporting comma delimited data

Does anyone have code for exporting an ADO recordset to comma delimited,
complete with header (if desired), quoting of data if the data contains
commas etc?

John W. Colby
www.ColbyConsulting.com 


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