View Single Post
  #9   Report Post  
Doug
 
Posts: n/a
Default

So, your suggestion was on point! I had to save it as a text file. Excel
did accept it and the import wizard came alive. I have not as yet verified
that the data are correct, but if not, the errors will be minor and
manageable. Thanks for the help. I've suggested to the brokerage that they
think about moving into the XML arena, although that may not be a good idea
either.

Luv ur refs to Les Miz! Cheers!

"Dodo" wrote:

"?B?RG91Zw==?=" wrote in
:

Well, I can, in fact, see it. In fact, I can copy it and the content
all shows up. I can paste it into Word and the data is there; same
with pasting into Excel. The "Open" command in Excel does not offer
me a CSV option, although (as you know, I'm certain) it does offer XMP
and other formats. Again, all of the MS help material says CSV and
Excel are compatible. Mystifying. Not sure how you might suggest I
download it (no FTP available at the remote site (plus the only two
format available, as I said, are QIF and CSV). Your suggestions will,
I can assure you, be more than welcome. Cheers!


Do I understand correctly that you can see it as some kind of a data sheet,
not as a filename in a directory or in a downloadable link?
If there is a link, right-clicking it might offer you to save it locally as
a file: "Save link as".

Because that is what you need, store it on your disk locally and open it
from within Excel.
That would give you all the tools to get it right in a sheet and do all the
things with it that Excel offers.

Excel can open text files in TXT - CSV - PRN formats.

So, is there really no way to get the data file?


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)