Write results of recordset to text file 
Author Message
 Write results of recordset to text file

I have a VB6 form that uses a access 97 database for a
backend. Using ado, i can create a recordset just fine. My
problem is that i would like to 'export' or 'save' these
results into a text file. Does anyone have any ideas?

Thanks in advance.


* Sent from RemarQ http://www.*-*-*.com/ The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!



Wed, 30 Jan 2002 03:00:00 GMT  
 Write results of recordset to text file
Use the Open File command.  Look up the syntax in the help.  You could also
use the FileSystem object if you set a reference to the Microsoft Scripting
Runtime library.

Joe

Quote:

>I have a VB6 form that uses a access 97 database for a
>backend. Using ado, i can create a recordset just fine. My
>problem is that i would like to 'export' or 'save' these
>results into a text file. Does anyone have any ideas?

>Thanks in advance.


>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!



Wed, 30 Jan 2002 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Reading from a text file and writing toa text file from Vis Bas 6.0

2. Write contents of listbox to text file/populate listbox from text file

3. How to write an asp script storing the result from a query in a CSV text

4. How to write an asp script storing the result from a query in a CSV text

5. writing formatted results to a rich text box control

6. Getting Text results vice Recordset from SQL Server

7. Writing comma delimited text files using double quotes - Write Statement

8. Writing query result set to ascii file

9. Writing vbs script results to a file

10. Needed text box for text written from write to left

11. Recordset as query result of recordset, possible?

12. Writing To Text Field Via Recordset

 

 
Powered by phpBB® Forum Software