How are you actually getting the info into the text file?
1) Putting the data in an Excel spreadsheet, then doing a Save As to a txt
file
2) Print #
3 Write #
4) FileSystemObject TextStream
a) Write
b) WriteLine
or what?


"Mervyn Thomas" wrote:

I'm using a concatenate function to draw data from Excel fields and so
including for each record the appropriate field lengths such as the
calculation for the first record (all of which is in A1).


=UPPER(CONCATENATE("1ROYTEST1.CSV",TEXT(Import!$G$ 1,"00000000"),TEXT(Import!$H$1,"000000")))

I think my problem which occurs when I import this file into a banking sytem
is that the overall record length is not determined and the import does not
know when the next record starts hence my request for an "end of record"
sybol or something. On ther model I have this record appears to be padded
with blanks up to 180 characters in all. Hope this explains
Mervyn




"Patricia Shannon" wrote in
message ...
What method are you using to create the text file?

"Mervyn Thomas" wrote:

I am creating a text file within excel and I do not know how to create
what
I think is needed and that is an end of line character for each line.
The
text is all in column A. The text file that excell creates appears to be
different to the model I am using in Notepad at the end of the line.
Anyone any experience in this?