[AccessD] ftp and access

after opening in an texteditor, do an edit and saving it, i couldn't import
it normally in access. I had to copy the data in an empty texteditor file
and then save it as textfile before i could import it.

The problem is that when opening the file in unix the text is in collumns.
after the ftp transfer the text isn't anymore.
The strange thing is that nothing changed in the way of handeling these
files, and suddenly the problem occurs.

Pedro Janssen




----- Original Message -----
From: "Sheri Hixson" <sdhi at kalamazoo.net>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Friday, May 07, 2004 5:21 PM
Subject: RE: [AccessD] ftp and access


> Thanks! Can't wait to see this!
>
> Sheri Hixson - SWMRIC
> Tollfree: 888-223-8634
> Email: mailto:swmrichelp at swmrichelp.com
> Web: http://www.swmrichelp.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Perry Harold
> Sent: Friday, May 07, 2004 10:56 AM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [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
>
>
> --
> _______________________________________________
> 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
>
>