[AccessD] Recordset into Text File

If the recordset is not a saved query but just a recordset, then one way
is to use something like this:

Open strFileName For Output As #NewFile

Then you write the records one at a time to the file.  A TextStream
object using FileSystemObject is another method.

Charlotte Foust

-----Original Message-----
From: Smethurst, Ryan [mailto:ryan.smethurst at bromley.gov.uk] 
Sent: Friday, April 25, 2003 7:27 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Recordset into Text File


---- London Borough of Bromley E-Mail Disclaimer ---- 
"For information about Bromley Council visit our web site
www.bromley.gov.uk" 
"The information contained in this message (including any attachments)
is confidential in that it is intended solely for the use of the
recipient to which it is addressed. If you are not the intended
recipient, the use of the information by disclosure, copying or
distribution is prohibited and may be unlawful." 
---- End of Disclaimer ---- 
Hi All, 
Can anyone tell me the best way to 'save/export' records from a
recordset into a text file? 
TIA 
RyanS