|
Wrong forum.
If you're using SQL Server, you're probably better off writing a CLR function to do that.
Work smarter, not harder.
modified 23-Sep-19 13:35pm.
|
|
|
|
|
Have you tried turning it off and back on again?
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
Or better, turn it on and then back off again.
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Then turn around and run.
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
Thank you sir, may I have another?
|
|
|
|
|
Is it yout turn yet?
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
EXECUTE xp_CmdShell 'FDisk'
Director of Transmogrification Services
Shinobi of Query Language
Master of Yoda Conditional
|
|
|
|
|
Here's a ghost from the past: Microsoft Money.
I've been using it since 1995, kept up with updates, and I'm currently running (still to this day) the final "sunset" edition MS published back in 2005. At this point it's basically free for all to download and use, with all the usual caveats that might entail.
These days I find myself tinkering with Power BI, and after getting used to what it can do, I'm starting to find MS Money's built-in reports somewhat..."lacking".
I otherwise like MS Money and don't necessarily want to transition/commit to something else. If I could just export its data every once in a while (even if manually) and refresh the data sources defined in Power BI to update any number of reports I might create, that'd probably be close to ideal...unfortunately, MS Money only allows exporting to what it calls "strict or loose" .QIF files. While Power BI can read from an impressive number of sources, QIF isn't one of them (and looking at their content, it probably shouldn't be expected to).
While QIF files seem readable enough, before I reinvent the wheel and try to convert into "something else" (exact details TBD)...has anyone come across anything that can either read MS Money files directly, or convert QIF files into some more common, spreadsheet (or DB) -like format(s)?
|
|
|
|
|
I am also still using the 2002 version. However, I have never found any information on the file format. It certainly feels like a database, but, I suspect, one that is unique to Money.
|
|
|
|
|
I suspect it would be easier to find support for converting from a format exported from MS Money (like .QIF as I mentioned) rather than reading Money's .mny files directly.
|
|
|
|
|
I never used money, but I used Works for a while (circa 1992). What I need is a way to read a Works database file.
|
|
|
|
|
|
|
That's pretty much what I had in mind. I was wondering if anyone had gone through the exercise already just so I could at least avoid that part. At a cursory glance, it would seem one could convert this into a small number of tables that would be easy to query.
|
|
|
|
|
This project might be helpful : Free Accounting Software | GnuCash[^]
It can import QIF files and source code is available.
"They have a consciousness, they have a life, they have a soul! Damn you! Let the rabbits wear glasses! Save our brothers! Can I get an amen?"
|
|
|
|
|
Thanks for the suggestion. At first I was rejecting the idea of using GnuCash--I don't want to switch programs--but ultimately if it's just to borrow its import source, then it's probably well worth investigating.
|
|
|
|
|
I always assumed it was an Access database with a different file extension, but I've never confirmed this.
|
|
|
|
|
Y'know, I've never tried that. I'm making a note to investigate that sort of thing when I get back to it...
|
|
|
|
|
Stretching is important, and stretching correctly is even more so:
- Stretch out flat on your back.
- Stretch your eyelids over your eyes.
- Stretch a blanket over your body.
Works for me. 
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
(4). Stretch a quick nap into an all-day experience.
Whenever you find yourself on the side of the majority, it is time to pause and reflect. - Mark Twain
|
|
|
|
|
Stretching the truth a bit, are we now?
| Ravings en masse^ |
|---|
| "The difference between genius and stupidity is that genius has its limits." - Albert Einstein | | "If you are searching for perfection in others, then you seek disappointment. If you seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
Real men do their stretching Mordor style[^].
I have lived with several Zen masters - all of them were cats.
His last invention was an evil Lasagna. It didn't kill anyone, and it actually tasted pretty good.
|
|
|
|
|
OriginalGriff wrote: Works for me.
every time, too. without fail. 
|
|
|
|
|
Don't forget to nap after a good workout.
|
|
|
|
|
...and then be ready to stretch again.
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
