Export to textfile

[A E]

Hi again,

first I would like to say thankyou to all MVP:s that is doing such a great
job in this community.

The problem I'm wondering about is this:

when I export my text file each field is written on a separate line in my
text-file, do I have to use more variables and do the print command for the
whole line first or is i possible to perform a print command and move on to
the next print session without having a new line in the text file.

Second: I'm curious about the field-length, I need to do a list with headers
and rows with a specified field-length and the receiver of this file I'm
building cannot handle separators like ",".

Many thanks in advance,

A E

 

[Klatuu]

See Access help regarding the TransferText method. I believe it will solve
your problem. If your target system will not handle delimited fields,
TransferText can also produce fixed length lines.