[AccessD] ftp and access

I've had files from *nix machines where I had to open with something like
WordPad, make one edit and when the file is closed the cr/lf's are saved as
windows ascii cr/lf's, then the file can be opened and imported.

Perry Harold

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos
Sent: Friday, May 07, 2004 10:42 AM
To: accessd at databaseadvisors.com
Subject: Re: [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


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com