RE: [vox-tech] Off Subject and (Probably) Remedial Question

[Cris Clausing <crisc@thevisioMAPSn.net>]

Jay,   Thanks for the suggestion!  I don't have control of the FTP process (just get 
handed the resulting files), but will ask the guy that does if he's doing that.  Cris

-----Original Message-----
From:   Jay Strauss [SMTP:jjstrauss@yahoo.com]
Sent:   Friday, April 20, 2001 3:00 PM
To:     vox-tech@franz.mother.com
Subject:        Re: [vox-tech] Off Subject and (Probably) Remedial Question

Maybe you need to set ftp to binary mode?

i.e.

c:> ftp
some stuff about userid and password
ftp> binary
ftp> get your_file


----- Original Message -----
From: "Cris Clausing" <crisc@thevision.net>
To: "'Ya'll'" <crisc@thevision.net>
Sent: Friday, April 20, 2001 4:36 PM
Subject: [vox-tech] Off Subject and (Probably) Remedial Question


> I, as a minion of the Evil (Microsoft) Empire, have built a couple of
Access databases which use (DOS) files FTP'd from a Unix system.
>
> When I import those files to Access they LOOK fine in the database tables,
with one line of data per row in the table.  HOWEVER, when I run an Access /
SQL  'COUNT' of records, the function returns a number much less than the
number of rows in the table.  When I cut-and-paste the table data to an
Excel spreadsheet, I end up with multiple lines/rows of data in a single
cell.
>
> I've looked at the files in a BINARY (HEX) editor and see, what appear to
me to be, valid  CARRIAGE RETURN LINE FEED ( 0D 0A ) values where they
should be ?.and  NO extra (non-printing) characters or code.
>
> I assume the FTP'd Unix files contain characters which I can't see using
my DOS / Windows application TEXT or BINARY (HEX) editors (?).
>
> My Questions:
> 1) a)  Is mine a valid assumption?
> b) Can / will a file generated and used / viewed in the above described
manner contain characters / control characters?
> c) Is there a DOS/Windows system application that will allow me to view
such characters?
> d) Can I copy the files (from my DOS/Windows system) to my  (HOME) Linux
system and use something (I'm a Linux Newbie) to view them?  IF so, which
application?
>
> 2) a)  Has anyone else run into a similar problem?
> b) Was it an issue with the Unix FTP program / interface ?
> c) How did you resolve it?
>
> 3) Am I asking the wrong group?  Could anyone suggest a reference /
web-site / book / ? (be nice)?
>
>
> My Undying Gratitude !!!
> Cris


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com