database to text file

Results 1 to 2 of 2

Thread: database to text file

  1. #1
    Joel Graham Guest

    Default database to text file

    I have database information that I need to parse into a tab-delimited text file. I&#039ve seen the parsing loop once it becomes a text file. I just have never seen the translation between the two. I presume it is relatively simple, butI have not been able to figure it out myself.<BR><BR>Can anyone help? Or tell me where to go to find it?<BR><BR>Thanx

  2. #2
    Join Date
    Dec 1969

    Default RE: database to text file

    As long as it&#039s not a really big recordset, this will work<BR><BR>Set outputstr = rs.GetString(2, , chr(9), vbcrlf, "")<BR><BR>and then print outputstr to a file with a textstream<BR><BR>If it is too big to practically handle in one pass, you can break outputstr into an array of strings<BR><BR>strarray = split (rs.GetString (2, , chr(9), vbcrlf, ""), chr(9), -1, 1)<BR><BR>and then loop through the array to output each string with the textstream.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts