Money's import file format question.

#1 07-29-2006, 03:50 PM

Thanks Dick. I'll give your suggestion a whirl!
Regards,
B.

"Dick Watson" wrote:

- quote -

> Two formats (major ones anyway) exist. QIF and OFX. Google and persistence
> should get you more data sufficient to get where you want to go.
> "Brcobrem" <Brcobrem[at]discussions.microsoft.com> wrote in message
> news:1BBB6891-0F65-4249-AD7F-F90B820AAB74[at]microsoft.com...
> > First, excuse me if I am using the wrong terminology. Actually I have only
> > seen Microsoft Money a couple times over the years. That said. . .
> > > Let's suppose that a bank can provide an electronic statement and they can
> > provide that statement in the Microsoft Money native import format. I
> > would
> > like to import that file into another database (ie. MSSQL). Can you please
> > tell me if this file is something standard like a "tab" or "csv" delimited
> > file that may also (but not necessarily) have header and/or footer rows?
> > > If it doesn't have a header row(s), then I would at least need to know the
> > file schema so that I would know which fields were what fields. Is there a
> > file definition for this available?
> > > I look forward to your reply.

07-14-2006, 12:19 AM

Two formats (major ones anyway) exist. QIF and OFX. Google and persistence
should get you more data sufficient to get where you want to go.

"Brcobrem" <Brcobrem[at]discussions.microsoft.com> wrote in message
news:1BBB6891-0F65-4249-AD7F-F90B820AAB74[at]microsoft.com...
- quote -

> First, excuse me if I am using the wrong terminology. Actually I have only
> seen Microsoft Money a couple times over the years. That said. . .
> Let's suppose that a bank can provide an electronic statement and they can
> provide that statement in the Microsoft Money native import format. I
> would
> like to import that file into another database (ie. MSSQL). Can you please
> tell me if this file is something standard like a "tab" or "csv" delimited
> file that may also (but not necessarily) have header and/or footer rows?
> If it doesn't have a header row(s), then I would at least need to know the
> file schema so that I would know which fields were what fields. Is there a
> file definition for this available?
> I look forward to your reply.

#-1 07-13-2006, 07:05 PM

Hi,

First, excuse me if I am using the wrong terminology. Actually I have only
seen Microsoft Money a couple times over the years. That said. . .

Let’s suppose that a bank can provide an electronic statement and they can
provide that statement in the Microsoft Money native import format. I would
like to import that file into another database (ie. MSSQL). Can you please
tell me if this file is something standard like a “tab” or “csv” delimited
file that may also (but not necessarily) have header and/or footer rows?

If it doesn’t have a header row(s), then I would at least need to know the
file schema so that I would know which fields were what fields. Is there a
file definition for this available?

I look forward to your reply.

Regards,
Brcobrem

Similar Threads
Thread	Forum	Replies	Last Post
Stock Quote format Question. Ken: I purchased a Preferred Bond Hybrid. The Stock symbol that works @ the Schwab web site is USB+I and USBpI works using StreetSmartPro (Schwab's...	Microsoft Money	2	05-16-2006 10:01 PM
Converting Money 2003 to 2006 file format failure Mike: I'm trying to evaluate Money 2006 however the update fails when converting my Money 2003 file. It fails with the "Money cant open this file because...	Microsoft Money	10	10-11-2005 11:25 PM
File Format Incorrect??? alan: I am trying to add an expense category to microsoft deluxe 2003 in the buinsess account. When I get to the creating a withdrawal and chose a...	Microsoft Money	2	07-29-2004 07:20 AM
Trying to import South African statement in CSV format Claire: How do I import statements to microsoft money? is there some way of converting a standard CSV file to an importable version? I am currently on...	Microsoft Money	1	05-27-2004 04:29 PM
Ask For Money Format Get Quicken File Kino Villager: Recently I had to reinstall Win Xp onto my PC. I reinstalled Money 2003 with appropriate upgrades. I also reformatted my HDs & was able to reinstall...	Microsoft Money	1	08-18-2003 09:56 PM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode