I need to export multiple records from the database to a text file but the problem is that I need to have all the records printed on one line and not each on a single line.
Do While Not rst1.EOF
Print #sessfile, Format(Str(rst1!number), "000000") ' & "000000" & invoice & " "
In this case, each record is printed on a single line, but I need to have all the records on one line. (without CR or enter)