l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2001 Dec 30 17:03

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Off Subject and (Probably) Remedial Question
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

  • Subject: Re: [vox-tech] Off Subject and (Probably) Remedial Question
  • From: jdnewmilMAPS@dcn.davis.ca.us
  • Date: Fri, 20 Apr 2001 15:04:32 -0700
  • References: 01C0C9A7.6C08A080@zz

On Fri, 20 Apr 2001, Cris Clausing wrote:

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

That there are special characters inserted by Unix that a DOS hex editor
cannot see? Which is the evil empire you referred to?

Um, No.

> b) Can / will a file generated and used / viewed in the above
>    described manner contain characters / control characters?

Huh?  You just said you saw crlf sequences... can you communicate/write
without equivocating everywhere?

> c) Is there a DOS/Windows system application that will allow me to
> view such characters?

See your local psychic or other new age therapist?

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

See above.

> 2)    a)  Has anyone else run into a similar problem?

Sounds like your data has errors, such that data type conversions are not
working.  Be sure you don't depend on Access to identify the data types in
the columns... it does a terrible job.

> b)    Was it an issue with the Unix FTP program / interface ?

Sounds like not.  Omitting the "binary" option on the ftp transfer could
cause problems, but I learned about those ages ago.

> c)    How did you resolve it?

Define tables with known column types, make sure they are empty, and
import the data again.

> 3) Am I asking the wrong group?  Could anyone suggest a reference /
> web-site / book / ? (be nice)?


> My Undying Gratitude !!!

First the minions of the evil empire, then the undead. Man, you are
scary! :)

> Cris

Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
Work:<JeffN@endecon.com>              Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...2k

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
O'Reilly and Associates
For numerous book donations.