Export fixed-width with Line feed only

[jahaines82]

Hey guys,

I searched the forums and couldnt find anything that directly related to my issue. What I am trying to do is export a fixed-width text file, but the issue is that the file has to be line feed only. By default Acces creates CR/LF and the client's import specification only allows for Line feed.

I am currently using a macro, with export specification, to create the file. Due to time constraints and other obligations, I am really trying to avoid VBA programming.

Thanks in advance,
Jahaines

 

[gemma-the-husky]

you probably have to use VB for this.

normal you write a crlf as vbcrlf (a vb constant for that)

lf on its own is just chr(13) (or is it chr(10))

any way,

string1 & chr(13) & strg2 & chr(13) etc will just add crs -

 

[jahaines82]

Thanks for the reply. I was thinking that I would have to go this route.

 

[gemma-the-husky]

fixed width might be hard anyway, via VB. you might have to declare a fixed array, and manually load numbers into it for instance.