file format

[MARK GARNER]

Hello all,

We get a file created from a Unix box. It is sent to us via MQ messaging.
When I try and import it into my access program it see everything as one
long line. When we open the file the data is skewed. If I open it in
WordPad and them use "save as" it corrects the format and then I'm able to
import it in.

Is there a way to use Vba and format this correctly?

I have use the filecopy command, but it did not work.

Tried this:
FileCopy "c:\t1.txt", "c:\t2.txt"

And even thought this might work, but did not.
FileCopy "c:\t1.txt", "c:\t2.doc"
FileCopy "c:\t2.doc", "c:\t2.txt"

 

[Chriske911]

Hello all,

We get a file created from a Unix box. It is sent to us via MQ messaging.
When I try and import it into my access program it see everything as one long
line. When we open the file the data is skewed. If I open it in WordPad and
them use "save as" it corrects the format and then I'm able to import it in.

Is there a way to use Vba and format this correctly?

I have use the filecopy command, but it did not work.

Tried this:
FileCopy "c:\t1.txt", "c:\t2.txt"

And even thought this might work, but did not.
FileCopy "c:\t1.txt", "c:\t2.doc"
FileCopy "c:\t2.doc", "c:\t2.txt"

open the file with a decent text editor (notepad++ for example) or any
hex editor out there
and you will see wich char is used at the end of the line
could be that there is only a CR char at the end of the line
this is not recognized as the end of a line in windows appz
you could import this file thru VBA and check on the char used as end
of line to separate the records

grtz