Database records from excel templates

[BeeJay]

How do i get data entered into a template form such as invoice to update a
database. This used to work in previous versions of excel and is mentioned in
help but no where does it tell you how to set the form to do this.

[Debra Dalgleish]

There's information on the Microsoft site for the template wizard for
Excel 2002:


http://www.microsoft.com/downloads/d...displaylang=en

BeeJay wrote:
> How do i get data entered into a template form such as invoice to update a
> database. This used to work in previous versions of excel and is mentioned in
> help but no where does it tell you how to set the form to do this.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Ragdyer]

Depending on your version, this might help also:

http://support.microsoft.com/dÂ*efau...en-us;8732Â*09

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
news:42B59FDC.80608@contexturesXSPAM.com...
> There's information on the Microsoft site for the template wizard for
> Excel 2002:
>
>
>
http://www.microsoft.com/downloads/d...displaylang=en
>
> BeeJay wrote:
> > How do i get data entered into a template form such as invoice to update
a
> > database. This used to work in previous versions of excel and is
mentioned in
> > help but no where does it tell you how to set the form to do this.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

[Ragdyer]

Try again:

http://support.microsoft.com/default...b;en-us;873209

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
news:OpjmZFPdFHA.1504@TK2MSFTNGP15.phx.gbl...
> Depending on your version, this might help also:
>
> http://support.microsoft.com/dÂ*efau...en-us;8732Â*09
>
> --
> HTH,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
> news:42B59FDC.80608@contexturesXSPAM.com...
> > There's information on the Microsoft site for the template wizard for
> > Excel 2002:
> >
> >
> >
>
http://www.microsoft.com/downloads/d...displaylang=en
> >
> > BeeJay wrote:
> > > How do i get data entered into a template form such as invoice to
update
> a
> > > database. This used to work in previous versions of excel and is
> mentioned in
> > > help but no where does it tell you how to set the form to do this.
> >
> >
> > --
> > Debra Dalgleish
> > Excel FAQ, Tips & Book List
> > http://www.contextures.com/tiptech.html
> >
>

[Beejay]

Thanks for this help. Unfortunately although I have downloaded the relevant
software, it doesn't seem to install. When I double click I get the microsoft
user agreement, click yes and then not a lot else happens and I can't
subsequently find the add in on excel.
Any suggestions?

"Ragdyer" wrote:

> Try again:
>
> http://support.microsoft.com/default...b;en-us;873209
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Ragdyer" <RagDyer@cutoutmsn.com> wrote in message
> news:OpjmZFPdFHA.1504@TK2MSFTNGP15.phx.gbl...
> > Depending on your version, this might help also:
> >
> > http://support.microsoft.com/dÂ*efau...en-us;8732Â*09
> >
> > --
> > HTH,
> >
> > RD
> >
> > --------------------------------------------------------------------------
> -
> > Please keep all correspondence within the NewsGroup, so all may benefit !
> > --------------------------------------------------------------------------
> -
> > "Debra Dalgleish" <dsd@contexturesXSPAM.com> wrote in message
> > news:42B59FDC.80608@contexturesXSPAM.com...
> > > There's information on the Microsoft site for the template wizard for
> > > Excel 2002:
> > >
> > >
> > >
> >
> http://www.microsoft.com/downloads/d...displaylang=en
> > >
> > > BeeJay wrote:
> > > > How do i get data entered into a template form such as invoice to
> update
> > a
> > > > database. This used to work in previous versions of excel and is
> > mentioned in
> > > > help but no where does it tell you how to set the form to do this.
> > >
> > >
> > > --
> > > Debra Dalgleish
> > > Excel FAQ, Tips & Book List
> > > http://www.contextures.com/tiptech.html
> > >
> >
>
>