converting to excel or access?

Hi all, A friend has a very old computer with an MS-DOS version of Quicken on it. Look like the computer is about to die and she has asked me if it's possible to save her quicken files.

From the research I've done it seems like there's a bit of a process of using trial versions of Quicken to convert the files to a current version. Does anyone have a link with info on this process?

My main question. I haven't used Quicken before and all I really know is that it's financial software. Can it be converted to either Excel or MS Access format and still be usable? My friend doesn't have any finance software on her newer machine, and she'd prefer no to go out and buy a new version Quicken. Is there any alternative?

thanks heaps, any info appreciated.

matt

Reply to
Matt Lobegeiger
Loading thread data ...

I do not think you can accomplish your type of conversion. What version of Quicken for DOS is your friend using? I know for sure that Quicken 8 for DOS will run on Windows 98 and Windows XP.

If you want I have Quicken 8 for DOS,or Quicken 2000 for Windows that I'll be willing to sell for $10 each or if you friend wants to treat him/her self good go for Quicken 2006.

Reply to
MedRxman

Thanks for that but I'm guessing it's much older. Like version 2 or 3 maybe?

Thanks for the offer, I'll get back to you.

matt

MedRxman wrote:

Reply to
Matt Lobegeiger

On Wed, 30 Nov 2005 10:42:28 +1000, Matt Lobegeiger wrote in alt.comp.software.financial.quicken:

If the old computer is truly getting weak, you might want to immediately export everything in whatever format that version of Quicken uses. Of course, you probably knew that but I had to say it.

If you are, or know someone who is, fluent in a language like Perl, it's fairly trivial to convert a Quicken QIF file into a comma-delimited file. That, of course, can go virtually anywhere.

Reply to
Dick Yuknavech

Actually, there is no need for Perl.

There is a free Excel macro available at

formatting link
which will "import" (open) a QIF file in Excel ... which can easily then be "saved" as a comma delimited file.

Reply to
John Pollard

Thanks for that, sounds very promising. I'll check it out.

matt

John Pollard wrote:

Reply to
Matt Lobegeiger

OK, that's interesting. I don't know perl but I've done a similar thing with VB before. So the QIF files aren't encrypted or anything? Once I've converted the file to CSV will it still be usable and updatable?

thanks heaps

matt

Dick Yuknavech wrote:

Reply to
Matt Lobegeiger

On Thu, 01 Dec 2005 01:44:47 GMT, John Pollard wrote in alt.comp.software.financial.quicken:

Egads. What a mind-bogglingly useful site. Bookmarked.

Naturally they don't have any to do some of the things I want to do with .QIFs (or .HTMs), so I won't erase Perl from my memory banks...yet.

Reply to
Dick Yuknavech

On Thu, 01 Dec 2005 11:56:29 +1000, Matt Lobegeiger wrote in alt.comp.software.financial.quicken:

Not encrypted. "Cryptic" maybe. The format is documented in a few places (do a Google). The QIF file is NOT the original Quicken data file. It's the format in which Q exports a data file, just as CSV is the fomrat in which Excel exports its data files. Both the QIF file and the CSV file will be good normal text files, so you can do whatever you want with them.

Of course John Pollard's post, which you have seen, has rendered the whole discussion moot. Thanks, John.

Reply to
Dick Yuknavech

Saving the historical accounting with (available) conversions to a spreadsheet would be fundamental accounting...Then new accountings must be begun (and good luck with the commercial shrink wrap).

However, you can set up an inexpensive DOS workstation computer since DR-DOS is available free for non-commercial use. Look for unoffical DR-DOS web sites that link to the DR-DOS ftp.

Also, a dual-boot computer can be configured and that most easily with a computer with two hard drives...In fact many computers that are a model or two step up from most basic are expandable and will just plug in an additional hard drive.

Reply to
A Count

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.