Hi<BR><BR>I succesfully created my txt file but finding it hard to loop the results of a recordset in to body of the text file, also cannot use recordset to name file. this is what I have:<BR><BR>dim filesys, filetxt, getname, path<BR>Set filesys = CreateObject("Scripting.FileSystemObject")<BR>Set filetxt = filesys.CreateTextFile("d: emp\"&soundex&".txt", True)<BR>path = filesys.GetAbsolutePathName("d: emp\"&soundex&".txt")<BR>getname = filesys.GetFileName(path)<BR>while not rs.eof<BR>filetxt.WriteLine(rs("id") & rs("name"))<BR>rs.movenext<BR>wend<BR>filetxt.Clos e<BR>If filesys.FileExists(path) Then<BR> Response.Write ("Your file, &#039;" & getname & "&#039;, has been created.")<BR>End If <BR><BR>