Export from mdb to txt
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 & " "
rst1.MoveNext
Loop
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)
thank you
Do While Not rst1.EOF
Print #sessfile, Format(Str(rst1!number), "000000") ' & "000000" & invoice & " "
rst1.MoveNext
Loop
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)
thank you
simply do a Replace(strname,vbcrlf,' ') on the exported string
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This code will produce a carriage return (line feed), but I want all the records to be on one line. So when printing other records they will be next to the previous one and not on a new line.
ASKER
The semi colon worked