This really is a windows problem, but its Unix related. I am hoping to find a kindred spirit who can help me....

=> I know I can use a sed to add the ^M to the line end, but in my customer does not have a Unix environment. The supplying party is unwilling at the moment to help us. <=

In text files created by Unix a line ends (and in those cases the record) with a linefeed (chr(10)) If you then want to import the file into access it sees it as 1 long line.
Now i have found that to be a major pain, and one can work around by reading the file character by character. This however causes the import to take a very long time.

Also i have noticed that in a certain environment, using A2k sp-3 on a win 2k machine access will accept the chr(10) as the "carriage return" thus importing the file properly. On other systems tho, NT/A97 and XP/AXP, it sees it as one line.

Does anyone have any info on the how when and why of this? I tried googling, MSDN and searching on the forum, but could not find anything trully relevant. Except maybe that Access should see it as 1 line, except for the earliest version (2).

Anybody?

Thanx

Hi namliam,
I don't know whether I've got the point, so you produce a file in a unix-like OS. After you send it via FTP in windows server to import it to Access. So you can use the ASCII option during FTP the file it will be sent to the server Windows with Line Feed and Carriage Return. Anyway if you have already the file and you don't have a unix-like OS then(I know that it is so stupid to tell it) open the file with a an advanced text editor(like TextPad or UltraEdit) and save it as a Dos file.

bye bye,
ducasio

You could also install cygwin and use the unix2dos utility.

Thanx for the suggestions....I am affraid that installing something/anything is not an option, my hands are tied on that end....

Changing the method of sending is the same, out of my hands and/or are not willing to change....

The process should be as automated as possible, we need to process multiple files ... Doing it by hand really is not an option either....

Sorry to be so limited, but thats what i have to deal with and get some work done as well.
Easiest would be for the sending party to do a sed command... but my grandchildren will be dead before they listen to me....

Thanx again for all suggestions... Also keep them comming cuase i am still stuck to doing it char by char...

Regards

The Mailman

Do you have flip?

If you cannot install or change anything, then you have NO options!
cygwin is free and the unix2dos utility can be run in batch.