HP3000-L Archives

March 2007, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Pete Eggers <[log in to unmask]>
Reply To:
Date:
Wed, 7 Mar 2007 21:25:53 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (30 lines)
I think OpenOffice.org's spreadsheet is much more consistant at importing
files, and the suite is smoother and more powerful linking to a variety of
database backends.

On 3/7/07, Walter J. Murray <[log in to unmask]> wrote:
>
> Michael Anderson writes:
>
> > IMHO, Excel has a lame import process, it try's to out-smart you while
> > doing things you just don't want it to do.
>
> That's what I discovered recently when I wrote a COBOL program to create
> a file for Excel to import.  I had to go through all sorts of gyrations
> to get Excel to import it correctly.
>
> One thing that helped immensely was changing the program to create the
> file as a tab-delimited file.  Once I did that, I was able to take all
> the defaults in Excel's import wizard.
>
> Walter
>
> Walter J. Murray
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2