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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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