Create database based on excel form
 

I have created an excel form using Excel 2003. Now I need to capture the form
information into a database prefereably Access 2003. I don't know if this can
be done. If yes then how?

It will be much easier to also create the user form in Access.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pitu" wrote:
|I have created an excel form using Excel 2003. Now I need to capture the
form
| information into a database prefereably Access 2003. I don't know if this
can
| be done. If yes then how?

I have created the form in excel because there is some logic inbuilt which is
much easier to do in excel then in access. Basically there are bunch of
anweres yes/no and based on all of them i am finding my final answer.

"Dave Patrick" wrote:

It will be much easier to also create the user form in Access.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pitu" wrote:
|I have created an excel form using Excel 2003. Now I need to capture the
form
| information into a database prefereably Access 2003. I don't know if this
can
| be done. If yes then how?

I would still do it all in Access.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pitu" wrote:
|I have created the form in excel because there is some logic inbuilt which
is
| much easier to do in excel then in access. Basically there are bunch of
| anweres yes/no and based on all of them i am finding my final answer.

I am sure there is a way in access to do this but at this point it has been
done in excel so I want to go further from there in designing a database to
capture the answers.

"Dave Patrick" wrote:

I would still do it all in Access.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pitu" wrote:
|I have created the form in excel because there is some logic inbuilt which
is
| much easier to do in excel then in access. Basically there are bunch of
| anweres yes/no and based on all of them i am finding my final answer.

Some of these may help you. There's no question you're going to spend much
more time trying to make this work than starting over using an Access
front-end/ back-end solution.

http://www.google.com/search?q=acces...&start=20&sa=N

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pitu" wrote:
|I am sure there is a way in access to do this but at this point it has been
| done in excel so I want to go further from there in designing a database
to
| capture the answers.

Thanks Dave for all the information that you gave. I will give a try to do in
access but since I don't know how to write logic code probably will have to
learn that first.


Dave Patrick" wrote:

Some of these may help you. There's no question you're going to spend much
more time trying to make this work than starting over using an Access
front-end/ back-end solution.

http://www.google.com/search?q=acces...&start=20&sa=N

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pitu" wrote:
|I am sure there is a way in access to do this but at this point it has been
| done in excel so I want to go further from there in designing a database
to
| capture the answers.

These may help you with that.

http://msdn.microsoft.com/library/de...mmersguide.asp
http://msdn.microsoft.com/library/de...tml/offaut.asp

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"Pitu" wrote:
| Thanks Dave for all the information that you gave. I will give a try to do
in
| access but since I don't know how to write logic code probably will have
to
| learn that first.