Read ofx file vb

Posted in XML. Aaron February 01, NET didn't agree how they should be represented. None of the microsoft stuff worked. Rydal Williams February 01, NET I too am trying to do this. I want to write a C basic application for inputing, and graphically displaying financial data. Part of this would be to download the data from the OFX servers.

I have the server locations for lots of servers, and the spec, I was just hoping someone already wrote a parser. I am completely against paying money for it, so I rather just write my own if I have to. Any help would be appreciated. George February 26, NET Have you gotten anywhere with this project?

It could only download statements from half the banks I tried with correct OFX provider information, and could not get it to read a.

Rick Strahl February 26, I decided to just break down and parse the data on my own and I'm about half way through the investment parsing stuff. It's not too bad, but I am seriously worried about implementation differences between the FIs. I'll have to deal with that once we have more data to actually test with - for now I'm working off a couple of accounts with a few of the big brokerages. I suspect it'll be the same with the banking data Norie - Even though I have worked out a solution I am still interested in your offer.

I have zero experience controlling IE through Access so I would appreciate the opportunity to learn. I still have to go out to my bank to download the file. If there is some way I could automate that process that would be really cool.

I'll PM you when I have more free time and maybe you can help me out. This is the code I came up with to parse the. Close rsImportBatch. Close rsImportBatchBalance. Number Resume sExit End Sub. But the only difference I can see with doing it in Access would be what you actually do with the data once you've extracted. The automation part shouldn't be any different.

If you try a search on the Exel forum you'll find various threads I've been involved with. Another board member, Right Click, has also posted on the subject quite a bit, and I think he's explored it more deeply than me. You must log in or register to reply here. Similar threads M. Manerlao Jun 16, Microsoft Access. Replies 1 Views 1K. Jun 16, Manerlao. AlexB Feb 9, Microsoft Access 2. Replies 10 Views 2K. Feb 19, xenou. Question Multiple external data files.

Markhad Mar 3, Excel Questions. Replies 1 Views Mar 3, Markhad. With Binary files often you will be using objects which are not of fixed byte length like Integers. For example you would want to read Strings from binary files together with other data types.

In such cases use the Type object data type when writing to a file. Learn more here. Below a simple example of reading a file to which a Type data type was saved to, including an Integer and String. You can try to read and process XML files similarly as text files shown above. However, given you will probably want to extract specific XML tag or attribute information I suggest reading my dedicated article below.

Above functions allow native upload of file data. However for more complicated scenario you will probably go for the FileSystemObject.