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

["Jay Strauss" <jjstraMAPSuss@yahoo.com>]

Naturally, the first question in weeks that I've been able to attempt an
answer (and did - I suggested binary).  And my reply never shows up (its
probably sitting in my outbox on my work machine)

I call I get credit for answering this question

Jay

----- 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