Transfer Data From MS Excel Form To MS Access Database – Simplified

About this tutorial:

Video duration: 1:14:44
Transfer Data From MS Excel Form to MS Access Database – Simplified

In this tutorial, we will learn how to develop an automated data entry application in Microsoft Excel and Access. We will utilize the MS Excel UserForm as Frontend and MS Access Database as backend of this application. You will learn the designing the userform, validating the entry made by users, email validation and connecting the Excel UserForm with MS Access Database with ActiveX Data Objects (ADO).

#ExcelAndAccess #TheDataLabs

Please follow the below link to download the Excel, Database and Support Files used in…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

15 thoughts on “Transfer Data From MS Excel Form To MS Access Database – Simplified

    Atiq Sarwar

    (February 16, 2020 - 3:05 pm)

    Yes Dilip… Video is very infomative, nice work.
    Did you test this on multiple user use it on same time?

    Aryan Khan

    (February 16, 2020 - 3:05 pm)

    Hey sir please create this type software

    Jafer Ct

    (February 16, 2020 - 3:05 pm)

    Hi sir
    This is a greate teaching..
    Very very helpull

    And i have one sujjestion
    Please make a video to editting the existing data and take report of employee details

    Of you seen this comment please like this comment

    mohammed elsayed

    (February 16, 2020 - 3:05 pm)

    Very good
    What about making a query
    In excel from access database??
    The opposite of that lecture!

    Trustline Facility Management Pvt Ltd

    (February 16, 2020 - 3:05 pm)

    Hi created customer database in access with photo

    Youcef Allali

    (February 16, 2020 - 3:05 pm)

    It is very interesting and very well explained. Thanks for sharing your knowledge. I am from Algeria.

    Rohit Gurung

    (February 16, 2020 - 3:05 pm)

    This was really helpful and brilliant…..I really appreciate your work….Thanks!!!

    Exogen Design

    (February 16, 2020 - 3:05 pm)

    Sir Thank you for this very much. I am moving now to Visual Basic to create my Stand Alone Point of Sale System. Basically I want to develop what I made with Excel to Visual Basic. Do you have some tutorial on Visual Basic?

    Amit Chauhan

    (February 16, 2020 - 3:05 pm)

    You are doing a wonderful Job, Dilip. Liked e way you simplify the process..Keep-up the good work.

    IDLE - Idiots Lab Entertainment

    (February 16, 2020 - 3:05 pm)

    Thanks for this video. It's.super useful. I have a query how to google search names from multiple cells from excell. Can you help with the VBA code.

    Garry Smith

    (February 16, 2020 - 3:05 pm)

    I do appreciate your efforts but here are a couple of points that I feel would have made your attempt better.
    First I could understand you better if you slowed down your speech. With your accent it was very hard to understand especially in the beginning and the end.
    Second, I do not see the point of using Excel if the user already has MS Access. It would have been much easier to just do this in Access than going through the connection process and then in the end you had to use an outdated version of Access.
    In the end I subscribed but please slow down you speech which may help to make your presentation easier to follow.
    Thanks for the video

    Atiq Sarwar

    (February 16, 2020 - 3:05 pm)

    Thanks… For sharing and teaching us….

    Qazi King

    (February 16, 2020 - 3:05 pm)

    Hello how are u? Thanks for a new video. I have sent u an email with an excel file on Data Entry Form. It has a bug. Please check it if you have some time.
    Very thank full to u..Love u….


    (February 16, 2020 - 3:05 pm)

    Just started watching the video it’s very useful thanks for the video

    Aurangzeb Alam

    (February 16, 2020 - 3:05 pm)

    The best video .
    Thanks for sharing your knowledge

Leave a Reply

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