|
Posted by Edward W. Thompson on November 12, 2007, 12:55 am
Please log in for more thread options wrote:
>Edward W. Thompson wrote:
>> I am still using Quicken 99. I know but it does everything I
>> need and
>> it's like an old friend. However, I would lke to continue
>> (restart)
>> to download and import data from my Bank which exports in
>> 'oft' and
>> 'csv' Quicken 99 requires 'qft' or 'qif'. Is there any way to
>> convert
>> 'oft' files to 'qft'?
>
>I think you'll file that "qft" is really "qfx" (and "oft" is
>really "ofx").
>
>> I have searched 'Google' but have not yet come across a
>> utility to do
>> this. Any ideas?
>
>MS Excel can "read" ",csv" files and the free Excel macro
>"xl2qif" can convert Excel "rows" of Quicken transactions into
>qif files. (Google for the macro).
Thanks John, have downloaded the macro but haven't tried it yet. My
last 'experiment', changing 'oft' to 'qft' resulted in the data being
imported but the dates of the transactions in the imported file were
in the US form (mm/dd/yyyy), not the form I use (dd/mm/yyyy). Took me
a while to figure out why the account would no longer balance!
|