table linked to text file producing extra rows

A friend's unix application produces various reports daily as flat
text files.

I link these files as tables in an Access (2000) database.

After linking, all of these reports begin with a blank row; no
problem.

But the latest report I've asked, once linked, creates not only a
blank row at the beginning, but a blank row after every row with data.

I suppose I could live with this, but I'd sure like to understand why
this is happening and how/if I can do something in the link
specification to prevent this from happening.

Thanks for any ideas.

Larry Rekow
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."

re: table linked to text file producing extra rows

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Linux (*nix) text files end each paragraph (or row) with a line-feed
(Lf). Window/DOS text files use a carriage-return/line-feed combination
(CrLf). You'll have to change the files before importing them.

Your friend may be able to save the file as a DOS file. I can't
remember the command, but I know there are utilities in Linux releases
that do that conversion.

Also, there are many *nix to DOS file conversion programs on the web.
Google for "unix2dos" or "u2d" or "unix to dos" or something along those
lines.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA+AwUBQRPbAoechKqOuFEgEQL/1QCY61NlzBVjCAK/W8uBuwdzT3eFKgCeNuPX
xE+dmUiJ4qAPDMIDqPkdiUo=
=9Kt6
-----END PGP SIGNATURE-----


Larry Rekow wrote:
[color=blue]
> A friend's unix application produces various reports daily as flat
> text files.
>
> I link these files as tables in an Access (2000) database.
>
> After linking, all of these reports begin with a blank row; no
> problem.
>
> But the latest report I've asked, once linked, creates not only a
> blank row at the beginning, but ablankrowaftereveryrowwithdata.
>
> I suppose I could live with this, but I'd sure like to understand why
> this is happening and how/if I can do something in the link
> specification to prevent this from happening.[/color]

re: table linked to text file producing extra rows

On Fri, 06 Aug 2004 19:24:58 GMT, MGFoster <me@privacy.com> wrote:
[color=blue]
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>Linux (*nix) text files end each paragraph (or row) with a line-feed
>(Lf). Window/DOS text files use a carriage-return/line-feed combination
>(CrLf). You'll have to change the files before importing them.
>
>Your friend may be able to save the file as a DOS file. I can't
>remember the command, but I know there are utilities in Linux releases
>that do that conversion.
>
>Also, there are many *nix to DOS file conversion programs on the web.
>Google for "unix2dos" or "u2d" or "unix to dos" or something along those
>lines.[/color]
++++++++++++++++++++++++++++++++++++++++++++++++++ +++++++++
Many thanks for you ideas. Indeed, this is the problem, but it
appears that I accidentally caused it myself.

i run a batch file on the windows box that is timed to automatically
ftp the report from the unix box each day after the report is run.

in my script, I left out the word "binary"; I had used this script to
fetch other text files successfully, but thought that, since the file
was text, the binary switch was not needed. I put the word "binary"
back into the script, and it all now works flawlessly.

Larry Rekow
- - - - - - - - - - - - - - - - - -
"Forget it, Jake. It's Chinatown."