Re: saving a select stament to a txt file

From: Val Mazur (group51a_at_hotmail.com)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 00:11:11 -0400

Hi,

You could save recordset into the file using Save method of it. Only option,
which allows to save recordset as a some sort of readable text is XML
format. In this case you code would look like

MyRecordset.Save "Path to the file", adPersistXML 

-- 
Val Mazur
Microsoft MVP
"msnews.microsoft.com" <yanive@nice.com> wrote in message 
news:%23$VpQX$cEHA.3148@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> How do I export /save the result of a select statment to a text file?
>
>
>
> Thanks,
> Yaniv
>
>

Relevant Pages

  • Re: filling a combo box and sorting
    ... Indicates one or more field names on which the Recordset is sorted, and whether each field is sorted in ascending or descending order. ... Each name is separated by a comma, and is optionally followed by a blank and the keyword, ASC, which sorts the field in ascending order, or DESC, which sorts the field in descending order. ... A temporary index will be created for each field specified in the Sort property if an index does not already exist. ... Setting the Sort property to an empty string will reset the rows to their original order and delete temporary indexes. ...
    (microsoft.public.outlook.program_forms)
  • RE: Query on Date range does not qualify the Year
    ... problem since it means that the column MUST be a text field for ADO purposes. ... recordset once you have retrieved it. ... you should be able to sort accurately by the NEW date field. ... > So what is happening is that Excel during the query determines the data type ...
    (microsoft.public.excel.programming)
  • Re: bind HTML table to ADO persisted recordset client-side
    ... I got it working with the object tag as follows ... ... refresh after clicking a column to sort). ... Instead of persisting the source ... you can open a recordset by passing it an XML ...
    (microsoft.public.data.ado)
  • Re: set order
    ... You can create an index on ADO Recordset by setting ... there is no way to set Sort equal to that index. ... while you can create any number of separate indexes. ... > you can just remove index and recreate it after bulk inserts/updates). ...
    (microsoft.public.vb.general.discussion)
  • Re: Sorting VBScript Array
    ... I would like to have the option to sort ... Michael Harris containing the word recordset. ... 'This sample code sets up a 3 by 5 array, adds data to it, ... Dim sMsg ...
    (microsoft.public.scripting.vbscript)