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:
Re: Create a CSV file
From:
"Walter J. Murray" <[log in to unmask]>
Reply To:
Walter J. Murray
Date:
Wed, 7 Mar 2007 21:15:21 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (20 lines) 
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 *

ATOM RSS1 RSS2