Database records from excel templates

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.

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> >
>
>