write in txt file in tabular mode

[sal21]

I use this code to print data in txt file... and have:

Code: Select all

While Not RS.EOF
For I = 0 To RS.Fields.Count - 1
Print #1, RS.Fields(I).Value
Next I
wend

aa
bb
cccc
dddd
ffff
ff
h
....

i need to write in txt file in tabula mode similar:

aa bb cccc dddd ffffff ff h
aa bb cccc dddd ffffff ff h
aa bb cccc dddd ffffff ff h

...

aa bb cccc dddd ffffff ff h

naturally maintain the same space from data...

how to?

[HansV]

How do we know where to start a new line?

[sal21]

How do we know where to start a new line?

SORRY...
modified my original post...

[HansV]

Doesn't the database system you're using have an option to export to a fixed width text file?

[sal21]

Doesn't the database system you're using have an option to export to a fixed width text file?

TKS suggestion but resolved with other code.