We cooked up an Excel add-in for this:
http://www.bigredconsulting.com/aboutofxreader.htm

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

We cooked up an Excel add-in for this:
http://www.bigredconsulting.com/aboutofxreader.htm

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

One approach you might try is using MT2OFX, which can read and write OFX
files (for bank/credit card accounts). You can easily read V1 and write
V2, which is XML-compliant. From there you can view it in IE or import
it into various programs.

http://www.mt2ofx.tk/ or http://www.xs4all.nl/~csmale/mt2ofx/ for more
info, or drop me a line.

Colin

Cal Learner-- MVP wrote:
- quote -

--
Remove REMOVE from email address to reach me!

Re: take the tags out.

Perhaps use Find and Replace All to take the tags out.

It should be under the Edit menu of Excel. I do not have Excel to test on
this computer.

If not in Excel, open the file with WordPad, you will find it there under
the Edit menu.

Hope this helps,
Ken

"phleduc" <Ph.Leduc[at]REMOVEcomcast.net> wrote in message
news:uFD$%23rfqHHA.4836[at]TK2MSFTNGP05.phx.gbl...

| It is funny you say it is not XML, it looks like XML (I got the same
| OFXHEADER:100 import error in i.explorer 7)
|
|
|
| Copying and pasting to excel works but gives me essentially the same (XML)
| like view as in notepad.(in excel 2003 as well as 2007) However, to copy
and
| paste my data in a useful way, I am still stuck with all the XML tags
which
| I do not feel like removing manually.
|
| I forgot to mention (but was hoping) that importing one way or another
would
| take the tags out.
|
| I am not an export in XML but does there exists some kind of schema for
this
| data to pull it apart more easily?
|
|
|
| Eventually this data will go into an Access database, does that make any
| difference?
|
|
|
| Philip
|
| "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
| news:4i2j635r1b3c228jd9j499valeobu09d9p[at]4ax.com...
| > In microsoft.public.money, Ken wrote:
| | > > My IE will not display *.xml. See Below....
| > | > > The XML page cannot be displayed
| > > Cannot view XML input using style sheet. Please correct the error and
then
| > > click the Refresh button, or try again later.
| > | > |
- quote -

| > | > > Invalid at the top level of the document. Error processing resource
| > > 'file:///C:/WINDOWS/Desktop/Bank.xml'. Line 1, Position 1
| > | > > OFXHEADER:100
| | > That header indicates that this is OFX 1 rather than OFX 2. OFX 2 is
| > XML, but OFX 1 is not.
| | > If you installed Microsoft Money, you could use MoneyLink to view
| > info from the Money file in Excel. Of course that would violate your
| > criterion. http://www.ultrasoft.com/MoneyLink/download.shtml
| | | | | > > ^Ken
| > | > > "Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
| > > news:risi63dam582vmam26vdmfe1c53sj7i83d[at]4ax.com...
| > > | In microsoft.public.money, Ken wrote:
| > > |
| > > | > Re: How easy is it to import/view a money ofx file in excel without
| > > having
| > > | > money installed?
| > > | | > > | > Reply: Very easy..
| > > | | > > | > One way to accomplish this....
| > > | | > > | > Open the saved bank ofx file with Notepad, on it's Edit menu choose
| > > Select
| > > | > All, this time on the Edit menu choose Copy.
| > > |
| > > | If he renames the file to *.xml he can view it in IE better than in
| > > | notepad. Copying and pasting from IE to Excel would then do what he
| > > | explicitly asks.
| > > |
| > > | | > > | > Open the Excel program, on it's Edit menu choose Paste.
| > > | | > > | > Ken
| > > | | > > | > "phleduc" <Ph.Leduc[at]REMOVEcomcast.net> wrote in message
| > > | > news:eb494RdqHHA.4108[at]TK2MSFTNGP06.phx.gbl...
| > > | > | How easy is it to import/view a money ofx file in excel without
| > > having
| > > | > money
| > > | > | installed?
| > > | > | (The ofx file is export from a banking program)
| > > | > | How do you do this?
| > > | > | I googled it but most stuff out there is either linking money with
| > > excel
| > > | > | (means you need money program) or moving an excel file into money?
| > > Cannot
| > > | > | find an easy solution, shoudl be becasue if you look at the file,
it
| > > is
| > > | > like
| > > | > | XML)
| > > | > |
| > > | > | Thx
| > > | > |
| > > | > | Philip
| > > | > |
| > > | > |
|
|

In microsoft.public.money, phleduc wrote:

- quote -

It's SGML, I think -- a relative of XML.

- quote -

.... and then to parse the data I expect.

- quote -

It is funny you say it is not XML, it looks like XML (I got the same
OFXHEADER:100 import error in i.explorer 7)



Copying and pasting to excel works but gives me essentially the same (XML)
like view as in notepad.(in excel 2003 as well as 2007) However, to copy and
paste my data in a useful way, I am still stuck with all the XML tags which
I do not feel like removing manually.

I forgot to mention (but was hoping) that importing one way or another would
take the tags out.

I am not an export in XML but does there exists some kind of schema for this
data to pull it apart more easily?



Eventually this data will go into an Access database, does that make any
difference?



Philip

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message
news:4i2j635r1b3c228jd9j499valeobu09d9p[at]4ax.com...
- quote -

In microsoft.public.money, Ken wrote:

- quote -

That header indicates that this is OFX 1 rather than OFX 2. OFX 2 is
XML, but OFX 1 is not.

If you installed Microsoft Money, you could use MoneyLink to view
info from the Money file in Excel. Of course that would violate your
criterion. http://www.ultrasoft.com/MoneyLink/download.shtml




- quote -

My IE will not display *.xml. See Below....

The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later.


------------------------------------------------
Invalid at the top level of the document. Error processing resource 'file:///C:/WINDOWS/Desktop/Bank.xml'. Line 1, Position 1

OFXHEADER:100
^Ken

"Cal Learner-- MVP" <via_newsgroup[at]please.tnx> wrote in message news:risi63dam582vmam26vdmfe1c53sj7i83d[at]4ax.com...
| In microsoft.public.money, Ken wrote:
|
| > Re: How easy is it to import/view a money ofx file in excel without having
| > money installed?
| | > Reply: Very easy..
| | > One way to accomplish this....
| | > Open the saved bank ofx file with Notepad, on it's Edit menu choose Select
| > All, this time on the Edit menu choose Copy.
|
| If he renames the file to *.xml he can view it in IE better than in
| notepad. Copying and pasting from IE to Excel would then do what he
| explicitly asks.
|
| | > Open the Excel program, on it's Edit menu choose Paste.
| | > Ken
| | > "phleduc" <Ph.Leduc[at]REMOVEcomcast.net> wrote in message
| > news:eb494RdqHHA.4108[at]TK2MSFTNGP06.phx.gbl...
| > | How easy is it to import/view a money ofx file in excel without having
| > money
| > | installed?
| > | (The ofx file is export from a banking program)
| > | How do you do this?
| > | I googled it but most stuff out there is either linking money with excel
| > | (means you need money program) or moving an excel file into money? Cannot
| > | find an easy solution, shoudl be becasue if you look at the file, it is
| > like
| > | XML)
| > |
| > | Thx
| > |
| > | Philip
| > |
| > |

In microsoft.public.money, Ken wrote:

- quote -

If he renames the file to *.xml he can view it in IE better than in
notepad. Copying and pasting from IE to Excel would then do what he
explicitly asks.

- quote -

Different way.

Try this....

Right click the saved bank ofx file, on the popup dialog window choose
Rename.

Rename it to... Bank.xls

Ken


"Ken" <PleaseReply[at]NewsGroup.Thanks> wrote in message
news:%23GevC2dqHHA.4180[at]TK2MSFTNGP04.phx.gbl...

| Re: How easy is it to import/view a money ofx file in excel without having
| money installed?
|
| Reply: Very easy..
|
| One way to accomplish this....
|
| Open the saved bank ofx file with Notepad, on it's Edit menu choose Select
| All, this time on the Edit menu choose Copy.
|
| Open the Excel program, on it's Edit menu choose Paste.
|
| Ken
|
| "phleduc" <Ph.Leduc[at]REMOVEcomcast.net> wrote in message
| news:eb494RdqHHA.4108[at]TK2MSFTNGP06.phx.gbl...

| | How easy is it to import/view a money ofx file in excel without having
| money
| | installed?
| | (The ofx file is export from a banking program)
| | How do you do this?
| | I googled it but most stuff out there is either linking money with excel
| | (means you need money program) or moving an excel file into money?
Cannot
| | find an easy solution, shoudl be becasue if you look at the file, it is
| like
| | XML)
| |
| | Thx
| |
| | Philip
| |
| |
|

Re: How easy is it to import/view a money ofx file in excel without having
money installed?

Reply: Very easy..

One way to accomplish this....

Open the saved bank ofx file with Notepad, on it's Edit menu choose Select
All, this time on the Edit menu choose Copy.

Open the Excel program, on it's Edit menu choose Paste.

Ken

"phleduc" <Ph.Leduc[at]REMOVEcomcast.net> wrote in message
news:eb494RdqHHA.4108[at]TK2MSFTNGP06.phx.gbl...
| How easy is it to import/view a money ofx file in excel without having
money
| installed?
| (The ofx file is export from a banking program)
| How do you do this?
| I googled it but most stuff out there is either linking money with excel
| (means you need money program) or moving an excel file into money? Cannot
| find an easy solution, shoudl be becasue if you look at the file, it is
like
| XML)
|
| Thx
|
| Philip
|
|

How easy is it to import/view a money ofx file in excel without having money
installed?
(The ofx file is export from a banking program)
How do you do this?
I googled it but most stuff out there is either linking money with excel
(means you need money program) or moving an excel file into money? Cannot
find an easy solution, shoudl be becasue if you look at the file, it is like
XML)

Thx

Philip