On Tue, 16 Jan 2001, Peter Jay Salzman wrote:
> dear all,
>
> i have a text file whose contents look like:
>
> "StudentID","Name","LabSection","DiscussionSection","Level","Major","Status","Email"
> "553892792","Kirk, James T",34,3.00,"SO","EMEC","RE","[EMAIL PROTECTED]"
> "626113319","Spock, Mister",30,3.00,"SO","EMEC","RE","[EMAIL PROTECTED]"
>
> i NEED to import this into a spread sheet, rather quickly. can some kind
> soul please tell me how to do this?
>
> the file itself is text. star office loads it using the word processor, but
> i really need this info in a spreadsheet.
File | Open | FileType="Text - txt - csv (StarCalc)"
File list will include ".txt" (tab delimited) or
".csv" (comma-separated-value) files, but you can enter any filename you
want.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<[EMAIL PROTECTED]> Basics: ##.#. ##.#. Live Go...
Work:<[EMAIL PROTECTED]> Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...2k
---------------------------------------------------------------------------