Create database based on excel form

P

Pitu

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?
 
D

Dave Patrick

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

:
|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?
 
P

Pitu

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.
 
D

Dave Patrick

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

:
|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.
 
P

Pitu

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.
 
D

Dave Patrick

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=access+database+excel+front+end&hl=en&lr=&c2coff=1&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

:
|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.
 
P

Pitu

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.
 
D

Dave Patrick

These may help you with that.

http://msdn.microsoft.com/library/d...eovroffice2000visualbasicprogrammersguide.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2kta/html/offaut.asp

--
Regards,

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

:
| 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.
 
Top