Import from Excel

Hi,
Is there any way I can import from MS Excel to Money?
--
Chanikya

JB
Mon Nov 07 05:07:54 CST 2005

See http://xl2qif.chez.tiscali.fr/xl2qif_en.php

"cndesu" wrote:

> Hi,
> Is there any way I can import from MS Excel to Money?
> --
> Chanikya

Dick
Mon Nov 07 07:29:03 CST 2005

See also http://umpmfaq.info/faqdb.php?q=8.

"cndesu" <cndesu@discussions.microsoft.com> wrote in message
news:05433109-7FE5-4E53-8DE2-E3E2F5A8B34B@microsoft.com...
> Is there any way I can import from MS Excel to Money?

cndesu
Mon Nov 07 11:22:06 CST 2005

Hi,
I have a pdf file consists of transactions which bank gave me online. Now
Can I import this file to money?
--
Chanikya


"Dick Watson" wrote:

> See also http://umpmfaq.info/faqdb.php?q=8.
>
> "cndesu" <cndesu@discussions.microsoft.com> wrote in message
> news:05433109-7FE5-4E53-8DE2-E3E2F5A8B34B@microsoft.com...
> > Is there any way I can import from MS Excel to Money?
>
>
>

Dick
Mon Nov 07 14:10:11 CST 2005

That would be really hard. First you'd have to convert the PDF to something
that you can deal with.

Could it be done? Yes.

With readily available tools in a simple way? No.

"cndesu" <cndesu@discussions.microsoft.com> wrote in message
news:D23EBB35-A367-4194-A345-F1ED311FF81B@microsoft.com...
> I have a pdf file consists of transactions which bank gave me online. Now
> Can I import this file to money?

cndesu
Sat Nov 12 20:29:02 CST 2005

Hi,
Can I have the suggestion or clue how they can be done from PDF to EXCEL or
directly to MONEY?
And one more thing just from the site online statement, I had selected and
copied the contents to excel worksheet. I deleted the unnecessary things
otherthan Date, Payee and Amount. But when I export to Qif file through the
tool provided by http://xl2qif.chez.tiscali.fr/xl2qif_en.php, I could not get
the amount values in the amount column. The remaining two columns were fine
with details just amount values are missing.
Chanikya


--
Chanikya


"Dick Watson" wrote:

> That would be really hard. First you'd have to convert the PDF to something
> that you can deal with.
>
> Could it be done? Yes.
>
> With readily available tools in a simple way? No.
>
> "cndesu" <cndesu@discussions.microsoft.com> wrote in message
> news:D23EBB35-A367-4194-A345-F1ED311FF81B@microsoft.com...
> > I have a pdf file consists of transactions which bank gave me online. Now
> > Can I import this file to money?
>
>
>

Dick
Sat Nov 12 21:54:36 CST 2005

What are you asking? How to do it? This will require programming. Help with
that is way beyond the scope of the NG.

"cndesu" <cndesu@discussions.microsoft.com> wrote in message
news:AFFBCFC1-DE30-4617-8D7F-B26BFADD76FE@microsoft.com...
> Can I have the suggestion or clue how they can be done from PDF to EXCEL
> or
> directly to MONEY?

cndesu
Wed Nov 16 20:20:09 CST 2005

Hi Mr. Dick Watson,
Any way I got the solution for converting PDF files to Money. Not
directlyconverting PDF to Money but I convert them Excel , to Quicken and
then to Money. Any way I also did little bit programming in that (VBA).

--
Chanikya


"Dick Watson" wrote:

> What are you asking? How to do it? This will require programming. Help with
> that is way beyond the scope of the NG.
>
> "cndesu" <cndesu@discussions.microsoft.com> wrote in message
> news:AFFBCFC1-DE30-4617-8D7F-B26BFADD76FE@microsoft.com...
> > Can I have the suggestion or clue how they can be done from PDF to EXCEL
> > or
> > directly to MONEY?
>
>
>

Dick
Wed Nov 16 22:09:45 CST 2005

Great!

Let me ask, how'd you get them from PDF to Excel?

"cndesu" <cndesu@discussions.microsoft.com> wrote in message
news:63326480-414F-40DF-ACB2-85F824C84130@microsoft.com...
> Any way I got the solution for converting PDF files to Money. Not
> directlyconverting PDF to Money but I convert them Excel , to Quicken and
> then to Money. Any way I also did little bit programming in that (VBA).

cndesu
Fri Nov 25 13:19:03 CST 2005

Hi,
Sorry for the late reply.
In Adobe Acrobat 5.0 there is a special tool as selecting tables like
selecting text and selecting graphics. with this tool I selected the data and
copied to Excel ( or even directly save that table as .csv file and open it
in Excel).
But the problem I faced if the payee field has more than one line then it is
occupying two rows in Excel. Then I wrote a macro to combine all that data in
two or three rows of single transaction into one. Then I converted the file
in QIF and then imported to Money.

--
Chanikya


"Dick Watson" wrote:

> Great!
>
> Let me ask, how'd you get them from PDF to Excel?
>
> "cndesu" <cndesu@discussions.microsoft.com> wrote in message
> news:63326480-414F-40DF-ACB2-85F824C84130@microsoft.com...
> > Any way I got the solution for converting PDF files to Money. Not
> > directlyconverting PDF to Money but I convert them Excel , to Quicken and
> > then to Money. Any way I also did little bit programming in that (VBA).
>
>
>

Dick
Fri Nov 25 14:48:39 CST 2005

Thanks. That's what I was wondering. You did not do the whole cycle
programmatically.

"cndesu" <cndesu@discussions.microsoft.com> wrote in message
news:652FED27-D6E8-454D-AFDF-FFBFA5CBA877@microsoft.com...
> In Adobe Acrobat 5.0 there is a special tool as selecting tables like
> selecting text and selecting graphics. with this tool I selected the data
> and
> copied to Excel ( or even directly save that table as .csv file and open
> it
> in Excel).
> But the problem I faced if the payee field has more than one line then it
> is
> occupying two rows in Excel. Then I wrote a macro to combine all that data
> in
> two or three rows of single transaction into one. Then I converted the
> file
> in QIF and then imported to Money.