View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Question for Userform Excel Wrksht vs Access DB

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.