I have created my first userform. This form will be emailed to users who are
requesting certain reports. When they return the form filled with data. I
want the data to be stored and saved in an Access DB. I know you can pass
the data from the form to a worksheet. However, then I would have to export
from worksheet to database (Access). Can the data from the UserForm go
straight to the Access Database. How do I do this? Can someone please help
me to do this? Thank you in advance for any help on this question.

See if you get any help from he

http://office.microsoft.com/en-us/ex...008521033.aspx

"TotallyConfused" wrote:

I have created my first userform. This form will be emailed to users who are
requesting certain reports. When they return the form filled with data. I
want the data to be stored and saved in an Access DB. I know you can pass
the data from the form to a worksheet. However, then I would have to export
from worksheet to database (Access). Can the data from the UserForm go
straight to the Access Database. How do I do this? Can someone please help
me to do this? Thank you in advance for any help on this question.

Sending data from XL ot Access is farily easy if you do it manually from the
access side. If you want to automate it however via code then you need use
ADODB Recordsets. There are lots of examples out there but the coding is not
a great project for the first timer...
--
HTH...

Jim Thomlinson


"TotallyConfused" wrote:

I have created my first userform. This form will be emailed to users who are
requesting certain reports. When they return the form filled with data. I
want the data to be stored and saved in an Access DB. I know you can pass
the data from the form to a worksheet. However, then I would have to export
from worksheet to database (Access). Can the data from the UserForm go
straight to the Access Database. How do I do this? Can someone please help
me to do this? Thank you in advance for any help on this question.

Thank you for your response. I will for now take the easiest route
possible as I need to implement this ASAP. I will go the worksheet route
then export to Access. However, I would eventually like to make this more
efficient and therefore would have to learn how to do it. What sites or
books do you recommend where I can get this knowledge/info. You mentioned
how do it manually, where could I find this? and also the ADODB Recordsets.
What does ADODB mean? Thanks for all your help.
"Jim Thomlinson" wrote:

Sending data from XL ot Access is farily easy if you do it manually from the
access side. If you want to automate it however via code then you need use
ADODB Recordsets. There are lots of examples out there but the coding is not
a great project for the first timer...
--
HTH...

Jim Thomlinson


"TotallyConfused" wrote:

I have created my first userform. This form will be emailed to users who are
requesting certain reports. When they return the form filled with data. I
want the data to be stored and saved in an Access DB. I know you can pass
the data from the form to a worksheet. However, then I would have to export
from worksheet to database (Access). Can the data from the UserForm go
straight to the Access Database. How do I do this? Can someone please help
me to do this? Thank you in advance for any help on this question.

To import into access follow the instructions posted by JLGWhiz.

ADODB stands for ActiveX Data Objects Data Base (which I'm sure does not
help you one little bit). A quick search of this site will get you lots of
hits.
--
HTH...

Jim Thomlinson


"TotallyConfused" wrote:

Thank you for your response. I will for now take the easiest route
possible as I need to implement this ASAP. I will go the worksheet route
then export to Access. However, I would eventually like to make this more
efficient and therefore would have to learn how to do it. What sites or
books do you recommend where I can get this knowledge/info. You mentioned
how do it manually, where could I find this? and also the ADODB Recordsets.
What does ADODB mean? Thanks for all your help.
"Jim Thomlinson" wrote:

Sending data from XL ot Access is farily easy if you do it manually from the
access side. If you want to automate it however via code then you need use
ADODB Recordsets. There are lots of examples out there but the coding is not
a great project for the first timer...
--
HTH...

Jim Thomlinson


"TotallyConfused" wrote:

I have created my first userform. This form will be emailed to users who are
requesting certain reports. When they return the form filled with data. I
want the data to be stored and saved in an Access DB. I know you can pass
the data from the form to a worksheet. However, then I would have to export
from worksheet to database (Access). Can the data from the UserForm go
straight to the Access Database. How do I do this? Can someone please help
me to do this? Thank you in advance for any help on this question.