Hugh,
Open Excel and then click FILE OPEN and simply open the text file.
Depending on how the text is formatted (commas, fixed length, etc)
Excel will either import it correctly or will open a wizard to help you
identify which data belongs in what column.
Jim Meagher
=====
Micro Solutions Consulting Member of The HTML Writers Guild
http://www.ezy.net/~microsol International Webmasters Association
410-543-8996 MS Site Builder Network - Level 2 member
=====
----- Original Message -----
From: <[log in to unmask]>
> I received a text file that is 1600 names and addresses. I am using
> netscape 4. I want to send these files to either excel 97 or access 97.
> I did a copy and paste in excel but I cannot get them separated out by
> member, address, city, state, zip, phone, and fax. How do I send this
> file to either excel or access then set them up so I can use them to
> either send fax or make mailing labels?
The PCSOFT web site always needs good submissions. If
you would like to contribute to the website, send any
software tech tips or software reviews to:
[log in to unmask]
|