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.

I've written hundreds, maybe thousands of COBOL extracts to CSV, and
then use Microsoft Access to import into a table, then export (Save As)
whatever (xls).

The Access import process is very full-featured, you can tell it to
ignore portions of the input file, data names, data types, and save
these specs for later..


my $0.02
Mike.


>>> kellie Jones <[log in to unmask]> 3/7/2007 11:53 am >>>
I've read the archives - and the only info I can find on CSV files is
converting 
to fixed from a csv file.

I was wondering if there was a way to create a *real* csv file on the
3000.

I don't have many resources - I can create a csv file with COBOL or
with 
QUIZ. What they really are is a fixed length file with commas in
between the 
fields. Problem is, if you open the file up in excel - there are extra
spaces, and 
it doesn't handle it correctly (you can see the data fine - but if you
need to 
load it into a database or do a lookup - it includes the trailing
spaces). I'd 
have to do a trim in excel and re-save the file to get rid of the
spaces.

Is there a way to do this in COBOL or even just from the OS? 

tia

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