Learn MS Excel – Video 382- VBA ADO – Import & Update Access Table from Userform -Part 3



Using ADO let us learn how to update and fetch information from access to excel and vice versa.

-~-~~-~~~-~~-~-
Please watch: “Learn Excel – Video 594 – VBA – WEB SCRAPING – CLICK ON SEARCH BUTTON”

-~-~~-~~~-~~-~-

3 thoughts on “Learn MS Excel – Video 382- VBA ADO – Import & Update Access Table from Userform -Part 3

  1. Hi Ajay. Can i have email your address. I want to learn excel individually from you. I'm interested to learn excel in the right way. Can you teach me. I'm not able to follow your videos in you tube. Help me.

  2. Absolutely wonderful series consisting of 3 videos. Your concepts are crystal clear. I have a request, can you please make a video on worksheet and workbook consolidation using vba ? Suppose, I have data scattered in 10 worksheets and I want to consolidate those data in a single worksheet. The field list is identical in all the worksheets, and each worksheet contains say 100 records, and I want to get 100 *10 records in a single worksheet with the same field list using vba. It can be done for workbooks also. Hope you have got my idea. Thanking you in advance.

Leave a Reply

Your email address will not be published. Required fields are marked *