Unix file to a spreadsheet

[teser]

Please advise on how I can output a Unix file to an Excel or Access spreadsheet?

 

[simanek]

I'm going to need a little more information in order to help. What format is the unix file in? If it's tab delimited, I know excel 2000 can open than up just fine. Also, comma separated fields will work. In both cases a new row is denoted by the carriage return. HTH. Mike
~~~~
simanek@uiuc.edu
"It's a Swingline!"
~~~~

 

[Sonk]

We simply use FTP to transfer files to our hard drive. From there you may open it with Excel making selections as you open it. Delimited file, choosing which columns to import, etc. It is very easy to do.

 

[mrunix]

You can use awk to pull the fields out of the file ( use printf to put commas ). Presto ... you have a .csv which you can ftp to your PC. Open the Office App first, then "Open" the ftp'd file.

Good Luck
mrunix