How to write a continuous line in a text file?

[Jay S.]

Hello,

I need to write a continuous line (without CR-LF) in VBA into a text file.
I tried opening the file as binary and used the "put" command but it inserts
the data type and length before the actual data. Is there a way to do this
in Access? Thanks in advance.

Jay

[Jason Lepack]

build the string in your loop and then use "Write" when you're all done
to output it.

dim strA as string
open filename for output as #1
strA = ""
do while not done
strA = strA & thenextpiece
loop
write #1, strA
close #1

On Jan 24, 9:58 am, "Jay S." <[e-mail]:

Hello,

I need to write a continuous line (without CR-LF) in VBA into a text file.
I tried opening the file as binary and used the "put" command but it inserts
the data type and length before the actual data. Is there a way to do this
in Access? Thanks in advance.

Jay

[Jay S.]

Thanks for your reply. I figured it out. I created a fixed 80 char string
and used "put" for every record. It didn't include the 2-byte var info
since it was a fixed length string. I didn't use "write" the way you did
because the line can go on for a while and there's a limit to a variable
string length (IIRC). Thanks again though.

Jay

"Jason Lepack" <jl*****@gmail.comwrote in message
news:11**********************@v45g2000cwv.googlegr oups.com...

build the string in your loop and then use "Write" when you're all done
to output it.

dim strA as string
open filename for output as #1
strA = ""
do while not done
strA = strA & thenextpiece
loop
write #1, strA
close #1

On Jan 24, 9:58 am, "Jay S." <[e-mail]:

Hello,

I need to write a continuous line (without CR-LF) in VBA into a text

file.

I tried opening the file as binary and used the "put" command but it

inserts

the data type and length before the actual data. Is there a way to do

this

in Access? Thanks in advance.

Jay