<div>
getrows and getstring<br />
<br />
check out there help and use it, it is far better than using/looping the rs objects<br />

</div>


getrows and getstring

check out there help and use it, it is far better than using/looping the rs objects


<div>
You could try incorporating DTS (Data Transformation Services) and Scripting.FileSystemObject<wbr />, it's a bit long winded but it should work. Infact you could suck the whole recordset in as a DTSFlatFile and spit the lot out to you delimited text file.<br />
<br />
Depending on how your retrieving your recordset? If its coming out of SQL using a stored Procedure it should be pretty easy.<br />
<br />
check this out:<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_basic_5zg3.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_basic_5zg3.asp</a>
</div>


You could try incorporating DTS (Data Transformation Services) and Scripting.FileSystemObject, it's a bit long winded but it should work. Infact you could suck the whole recordset in as a DTSFlatFile and spit the lot out to you delimited text file.

Depending on how your retrieving your recordset? If its coming out of SQL using a stored Procedure it should be pretty easy.

check this out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_basic_5zg3.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_basic_5zg3.asp]

<div>
Navstar16,<br />
<br />
good point getrows would be A hell of a lot easier!!!!!!!!!!!!!
</div>


Navstar16,

good point getrows would be A hell of a lot easier!!!!!!!!!!!!!

<div>
The recordset is coming out of sql. I'd like something that sucks the entire recordset into a file with the option to delimit fields and crlf at each record. <br />
<br />
I'll check out DTSFlatFile.
</div>


The recordset is coming out of sql. I'd like something that sucks the entire recordset into a file with the option to delimit fields and crlf at each record.

I'll check out DTSFlatFile.

<div>
<div class="content wysiwyg-content">
Is there a way to read the entire recordset row in order to write to a file in one shot and add delimeters to the fields without looping through each field? 
</div>
</div>


Is there a way to read the entire recordset row in order to write to a file in one shot and add delimeters to the fields without looping through each field? 

Read an entire ado recordset row?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.