Convert data files to Excel
Catherine Litten
catherine.litten@valleypres.org
Mon, 10 Dec 2001 17:11:43 -0800
When creating downloads for excel - I usually included the commas and quote
delimiters as defined items in the file so it is ready to upload into excel
and "SET SUBFILE PORTABLE" so that the spacing is consistent and the
numerics come out right.
Hope this helps,
Catherine Litten,
Senior Programmer Analyst
Valley Presbyterian Hospital
www.valleypres.org
***Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient (s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message.***
-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Thomas, DeNise M.
Sent: Monday, December 10, 2001 4:00 PM
To: powerh-l@lists.swau.edu
Subject: Convert data files to Excel
I'm trying to move a quiz subfile to Excel. I've emailed myself a text
file that I've renamed with the excel file extension which works fine
except when opening it, I have to tweek it a bit to make the columns fit
correctly. I've delimited this file with a "|" and with a ",". Both do
the same thing. I would like to be able to have this file open without
having to tweek the file. Any suggestions?
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.