 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / December 2007Question for Userform Excel Wrksht vs Access DB
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 here: http://office.microsoft.com/en-us/excel/HP052008521033.aspx > 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 [quoted text clipped - 3 lines] > 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...  SignatureHTH... Jim Thomlinson > 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 [quoted text clipped - 3 lines] > 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. > 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 [quoted text clipped - 8 lines] > > 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. SignatureHTH... Jim Thomlinson > 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 [quoted text clipped - 16 lines] > > > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.