Writing to a text file from a recordset

[shep6]

Can anyone help me out with the code needed to write data (3 fields) contained in a DAO recordset in Access to a .txt file. After each line I need to put a carriage return. I guess I need to loop through the recordset writing each line to the text file, but I am not sure of the code needed.

thanks in advance.

ps. there is no table which holds this data, and I don't want to create a temporary table to hold it first.

 

[bryanbayfield]

I don't know the Access model, but know the method you need.

Open file-name as string for append as #1
loop defined here
Print #1, output-string
return to top of loop
Close #1

At each iteration of the loop, the output-string will print on a new line. SuperBry!

 

[shep6]

Thanks, now sorted, this pointed me in the right direction!