Date:         Wed, 6 Dec 2006 15:06:09 -0500
Reply-To:     John Birken <zbq5@CDC.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         John Birken <zbq5@CDC.GOV>
Subject:      Re: ODS Markup ExcelXP
Content-Type: text/plain; charset=ISO-8859-1

Keith:


1. Check your ASCII in a true programming editor. Notepad doesn't show all
text problems. I expect data from my mainframe to have extra characters -
not the garbage you’re describing though.
2. List/send me 2 lines of the ASCII you’re trying to import. You can use ^
for garbage characters (if need be
-otherwise it may not be transmitted) and send me the few key stroke you
use to get into excel.
There may be simple solutions to your problem.

HTwillH,
John jbirken@cdc.gov


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Keith
McWhorter
Sent: Wednesday, December 06, 2006 1:11 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: ODS Markup ExcelXP

Gerhard,

In the Excel spreadsheet it was truly garbage. However, I took your advice
and looked at the data created on the mainframe and it is readable xml/html.
I file transferred it to the PC as ASCII and it is readable in Notepad.
However, attempting to open in Excel causes a pop up window
called "Problems during Load"  "problems came up in the following areas
during load:" and in the window below it lists "Style".

At least I'm a little closer!

Thanks,
keith