[AccessD] ftp and access

Hi Pedro,

Text type files in UNIX world are only Carriage Return - CR (Or is it only 
Line Feed??) delimited where in Windows world they are CRLF delimited. 
Sometimes in the transfer of files between the two worlds these special 
characters get stripped off or added on by the FTP Process. You will have to 
play around with different options to see if you can get them to work right. 
I have also had the joy of finding that if I didn't name the file with a 
.txt file extension it didn't transfer correctly as text format. That was a 
transfer TO the Unix world though.

Gary Kjos
garykjos at hotmail.com





>From: Gustav Brock <gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] ftp and access
>Date: Fri, 7 May 2004 16:15:52 +0200
>
>Hi Pedro
>
>Sounds like a problem with new lines (Carriage Return and/or Line
>Feed) - both should be present when the file is used in Windows.
>
>Check if the FTP client has some settings for these.
>
>/gustav
>
>
> > Hello group,
>
> > for some reports, i import txt-files in access with data of our hospital 
>unix system. These txt-files are made from the unix data with an FTP client 
>server that is present in Reflection emulation
> > software for windows. I choose to make it txt files with an ftp server 
>because of the advantage of transporting the file to the windows system and 
>making ASCII textfiles from them can be done in
> > one action (clicking a button with Vba code behind it). The file in unix 
>is in delimited space between the columns and normally after the ftp 
>transfer these columns in the txt-file still exist, so
> > that i can use import -specs in access to import them. But suddenly 
>after the ftp transfer, the columns in the txt-file don't exist anymore. Al 
>the records are placed behind the other. Nothing has
> > changed in the Vba code with the transfer.
>
> > I know this isn't a ftp forum, but maybe anybody experienced this 
>behaviour before?
>
> > Pedro Janssen
> > Cytologist
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com