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

[@atiqsarwar4222]

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

[@thedatalabs]

Thanks for your feedback! Yes, this tool will work. You just need to keep the database file on shared drive and change the path in Connection String provided in Support file and replace the old connection string with the updated one. Note: MS Access is required only for Development and Coding purpose. ADO and VBA will work without having MS Access on any of the system where user is using this form to transfer the data. Thanks!

[@atiqsarwar4222]

Thanks... For sharing and teaching us....

[@amjadansaree]

Awesome ... full of Knowledge

[@jovenvilla386]

good day sir i am your view ...i make a data base ...base on you video ...thank you sir ....but i have lot to learn ...i'm keep watching other video of thedatalabs

[@suraniakbar]

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

[@jovenvilla3548]

thank you so much sir ...i made my project ....learning from your videos :)

[@rohitgurung909]

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

[@VS-ed8od]

Very informative tutorial, This gave me some ideas to create invoicing for my small business.. THANKS

[@chocorrol922]

Thank you for sharing!

[@aphelelebhembe1091]

Thank you so much Dilip for your lessons they really help alot

[@amit15491]

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

[@thedatalabs]

Thanks for your appreciation!

[@youcefallali378]

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

[@thedatalabs]

Thanks for your feedback!

[@bonakgamingtv]

Great Video! Wonderful Job.. try to create Document Tracking . Thank you and More POWER!!!

[@naren254]

It is very helpful and well designed. Thanks

[@thedatalabs]

Thanks for your feedback!

[@pramburn]

Genius at work - nice one

[@thedatalabs]

Thanks for your feedback!

[@AZMDKN]

Excellent 👍

[@rajeshvarma8004]

Thanks 😀

[@jayjoarque4535]

Thank you so much for this tutorial sir, Can you add Search and Print option for this sir? Thank you

[@jeongseungchon]

very good...

[@kb7417]

Awesome...thanks brother...

[@rudolfkiruchi9393]

Great works

[@BANEBRO2]

Love this content your deserve more subscribers

[@adonisababan9042]

i am very glad this video, can you make a video for find, update the data? pleased.

[@BANEBRO2]

you r doing great Dear Best of luck wish u have more subscribers

[@Anukiranvlogs]

Thank you very much

[@ravindrametri1681]

Nice sir, plz make video to add image

[@shobha.g.sshankarappa2942]

Excellent Video.... Thank you so much I am searching since long time for video like this. thanks lot... please can you guide me how to design tables for a employee hiring and transfer maintenance DB in various branches of a company for employees. please. 1. DB should allow to assign employees to vacant posts, if already assigned it should show it is already assigned. 2.Once employee is assigned to a Post then status of post should change to filled from the date of appointment to till the date of removal/resignation/transfer of employee. 3.If employee resigned and transferred, then the status of post should become Vacant and then it should allow us to assign other employees to that post from the date of vacant 4.DB should record various employees worked in a post for different periods. 5.DB should show us no of posts filled and no of post vacant at any time. please guide or make video on this please... I am desperately needed this please.

[@tiktik9036]

Awesome.... How can we use dependent dropdown in this? .... Thanks in advance

[@mathematicswithpython2170]

I do appreciate to this work its really very helpful for me but could you guide us with other video which consist on data Manipulation or import or export with images picture from database to vba and vice versa

[@thedatalabs]

You can visit our website. Have posted a article on that. Will upload a tutorial covering image control. Thanks!

[@jaferct4218]

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

[@thedatalabs]

Sure, I will try to make. Thanks for your feedback!

[@rajeshvarma8004]

Great work Dilip. would like to know how to make correction to a recordset also

[@thedatalabs]

Thanks for your feedback! We will post a tutorial covering edit, delete and search.

[@victordyusha3977]

Hi. I have two questions 1) is it possible to display the data stored in ms access in a list box? 2) if it is possible will you be able to select a row edit it and print it? I saw your other video where you had a list box to show information in one of excel sheets, but just want to know if the same thing can be done for data stored in ms access. Hope to hear from you the soonest

[@thedatalabs]

Yes, both are possible. You can replicate the same code and techniques but before doing that create a sheet and fetch all data from MS access to that worksheet and then link the range to listbox. Take Care, Thanks!

[@victordyusha3977]

TheDataLabs hi I managed to write a code to fetch data from ms access and wrote it in excel worksheet and am now able display the data in the list box

[@Rwt.aje1]

@@victordyusha3977 sir can uh help me with the code. I have a doubt that at one of point data will be so heavy that importing in excel sheet and after updating the record loading it into the database again will make it duplicate.

[@Rwt.aje1]

Awesome video. Can we add listbox in this which is connected to the access database real-time and show only details of the agent who has logged in the form.

[@sarpongstephentakyi6784]

Assume you have different worksheets in ms access, how will you go about thad

[@aaa-lu7pq]

hello thank you. how to connect if the access file is stored online? like in a sharepoint site? thanks. i don't know how to do it.

[@funlearnunlimited4672]

This is amazingly helpful(considering I have no idea about any of the this). I managed to run on my machine successfully. However, I have a query. I am planning to keep database on network drive and share excel to different users. Is there a way I can have these users connect to access from different locations(including within India and outside) would be great if you can provided detailed instructions to achieve. Thanks in advance for amazing support video!

[@thedatalabs]

Thanks for your feedbacks! Please keep both Excel and Access file in same folder on shared drive. Create a shortcut of Excel file and share it with users. Ask them to open Excel file in Read-only. It will work properly.

[@funlearnunlimited4672]

@@thedatalabs sure I will try same. I have already kept it in shared drive(it was guess...:-) ) I will now create shortcut and share it. Just to know, have you created any video on searching a record based on value in text box and showing results in the form? Also, if there is a video to filter access database records and show on listbox based on certain text search. I am okay with 2 different search text boxes

[@funlearnunlimited4672]

@@thedatalabs I tried sharing the file but it does not work. without enable edit they cannot click the button. and in edited mode the file is searching for the path in local user 'downloads' folder

[@idle-idiotslabentertainmen7189]

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.

[@thedatalabs]

Thanks for your feedback! Coding for Searching on multiple columns will be little bit longer and complex . I will try to post a blog on our website. Please subscribe our newsletter on website so that you can get notifications. Thanks!

[@simbarashevhovha8401]

Thanks Dilip, I wanted to have to deploy the system entirely in excel without using MS Access

[@thedatalabs]

Please watch this tutorial. Thanks! kzbin.info/www/bejne/bH3WhqCpqa-Cjpo

[@simbarashevhovha8401]

@@thedatalabs Thanks Dilip, you are a star, it worked wonders. I had to endure watchign adverts on your video because you had provided me with a good solution. Thumbs up!

[@mohammedelsayed3852]

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

[@chiragjoshi3400]

Hi Sir, I have one question, I have created an access database (accdb) and Excel user form is linked with that and all userform record is saving into the access database. now database is saved in onedrive and it is shared with many users. Thus, when the users are entering records simultaneously then creating separate access databases for each user and when a single user is entering records then it is working fine. Could you please help me to fix this issue?

[@alicheema9094]

Great work Dilip. I used the same code and it placed it in shared environment. I can add the data and works fine for me but if any other user try to use the same, the excel file crashes and restarted again in recovery mode. In database no entry is found but with auto number in database one can understand that somebody tried to insert data. What can be the issue. We check the file in shared and non shared status, the error remains as it is.

[@swethasivashanmughakumar9649]

Hi Sir Thankyou so much for this video. While submitting the data I’m getting “Out of present range” error. Could you pls help with this ?

[@exogendesign4582]

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?

[@riolinardo55]

I wonder is it possible multiple user using this data entry form and save at the same and real time

[@Maynardjones100]

Thank you for this Dilip. Very nice explained I followed your tutorial step by step and it worked ONLY if I save the files to my local computer, but if I save it to an OneDrive location (I plan to share this with several users) I get "not a valid file name" error. Any Idea why this could be? thanks in advance!

[@thedatalabs]

Thanks for your feedback! MS Access doesn't support cloud as of now. Please keep it on shared drive for multiuser environment.

[@charlesdawnbeltran9603]

Nice content. Is it possible to store the MS Access file into Google drive or any free cloud storage to make the system online?

[@thedatalabs]

Thanks for your feedback! You can utilise Google Drive and Google Sheets to transfer data from Excel. Please watch this tutorial. kzbin.info/www/bejne/amqXd3mgnqtoedE

[@alializadeh8195]

Thanx

[@mydwightstifler]

Hi. I might be too late to watch, but is it okay to have the Excel document shared to everybody? When I say share, everyone in my team will download the excel file individually and fill them up? Also, the accesa database will be saved in One Drive, would that work? Amazing work here! Thank you!

[@oyexsabiansyah9458]

Master..How to add stock in vba excel with database access..?

[@charlesdawnbeltran9603]

Hi this is very nice video. Can we also save the MSAccess file into cloud server if we don't have a shared drive? If yes, do you have a sample of cloud server and how to connect Excel to Access. Thank you

[@thedatalabs]

Unfortunately, there is no option to host MS Access database on cloud. 😕 Alternatively, you can use SharePoint list as a replacement of MS Access tables. Thanks!

[@charlesdawnbeltran9603]

@@thedatalabs Thanks for the response. How much will it cost me to get a sharepoint list? Will the codes be the same to connect to Excel?

[@ganeshkanade5456]

It is very nice video, i planning for similar project but my doubt Is that is it necessary to install ms access in shared folder? And is there any option instead of opening the excel file n then opening the data entry form, by double clicking on the excel file which will directly open the user form.. Thanks in advance for the reply..

[@thedatalabs]

MS Access is only required to create the database. To use the tool, MS Access is not required. To directly run the form, you need to add the the Excel file as a trusted file so that it wouldn't ask everytime to enable the macro. After doing that, you can open the user Form in full window so VBA will hide the Excel window behind the user form..

[@365Journeys-v7c]

Hi Sir, I hope you are doing great! Will it work for multiple users. My question is if multiple users submits the data at the same time will it work. Pls help.

[@yarramkartheekreddy9163]

Yes it will

[@vinodtopiwala7669]

How to update support file in excel or data used with combo using VBA excel - Thanks

[@kb7417]

Brother, is there anyway we can retrieve the data from access to excel for updating the record? If that can be done will be awesome. I would like to request a vidoe from on that. Will really appreciate. Note: Retrieving the data back to userform and updating

[@amritbakshi8434]

Yes, exactly!! Anyway we can do this, specifically create a version thats distributed to others who we do not want to change the database & a separate form for editing the database from the form

[@learnwithdkg]

Bhai kya aap exe application bana sakte ho aur uska database access ho

[@bumpersmith]

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

[@thedatalabs]

Thanks for your feedback. I will definitely work on all those points suggested by you. Here, We need MS Access for development purpose only. In production, we don't require MS Access. ADO and VBA code will work without having MS Access installed on a system. You can use the latest database extension and that will definitely work. On my current system, it was not supporting hence, I had to switch to .mdb extension to complete the tutorial. Thanks!

[@bumpersmith]

@@thedatalabs Thanks for taking the time to reply. I see the benefit of not needing Access on the users system, just using Excel to feed the data after a database is copied to their computer. What is the purpose of using an ADO connection over DAO?

[@amritbakshi8434]

Can you edit records already in the database

[@biplabmazumder3870]

What would be the code for multiple options button

[@wellafareyahoocom]

Many thanks,Could you please share the final files and link

[@thedatalabs]

Please download the file from the link provided in description box. Thanks!

[@PiXpilot_Shridhar]

Very informative video, This is what I was looking for, Could we perform the logical & arithmetic operations, Getting the data to list box using this method (MS access) ? If we can please upload the tutorial. That will be very helpful. If you understand, pls do reply 🙏🙏

[@thedatalabs]

Thanks for your feedback! Will upload a tutorial covering the suggested features as well.

[@charleskikoth1463]

Thanks for your video brother. but i wanted to add more buttons unfortunately i got this error code "Item cannot be found in the collection corresponding to the requested name or ordinal.3265" How to solve please.

[@reagansendwe]

Salut je une petite problème et le problème est que je voulais connecté les tables Access sur des UserForm de Excel. Merci pour votre réponse

[@charlesdawnbeltran9603]

Can we run multiple queries in one sub function?

[@thedatalabs]

Yes, we can. Thanks!

[@charlesdawnbeltran9603]

@@thedatalabs Do you have a sample script? Thanks a lot

[@veefronda2747]

Hi Dilip. Thank you for this tutorial. However, i have encountered an error "run-time error 3706 - Provider cannot be found. It may not be installed properly. I am very new to vba. What should i check and how can i check it, and what needs to be done to resolve this? Hoping for your response. Thank you in advance.

[@thedatalabs]

Hello, it seems there is issue with Connection string. Please share the connection string code here so that I check and get back to you. Thanks!

[@amitharajkumar7916]

the output id calendar is "mm/dd/yyyy" ito the text box, how to convert to "dd/mm/yyyy"

[@deepakraazsingh6603]

Bro please make a date picker in BS Date or Nepali Date

[@deepakraazsingh6603]

I am from Nepal

[@jailbirdx0x]

code on how to save a selected item in combo box to Access DB?

[@jaisilon]

Hi ... I am getting Database Error - Either BOF or EOF is True or the current record has been deleted. Requested operation requires a current record.3021 Please Note- I follow the video and the correctly but still getting this entry As I am entering data on Userform and transferring it to MS Access Database At present the database is empty Please help in resolving the code

[@rkmishra4090]

Hi i have stuck in nConnection.Close. error showing "run time error 3704" operation is not allowed when object close. after run submit form showing--- object does not support this property method '438' please help to resolve error

[@thedatalabs]

Please check the variable nConnection. Share your code here so that we can review and fix the issue. Thanks!

[@PDPTUNBP]

How to add "Private Sub cmdUpdate_Click()" and Add "Sub Update_Data()"

[@hansakaerandaranasinghe6455]

wow

[@anandchaudhari901]

How to import....colomn to column

[@HeartTouchingrs]

Here the file will work in window 7 ms Excel2007

[@arminpiruz6246]

Sorry.. I didn't get what's the reason for using Excel Form and not Access Form itself..

[@ebnest3191]

your site has a lot of ads and all of them says "download"... one could have downloaded a virus or malware for people who are not careful.

[@Andrew-of9of]

Where are the support files?

[@thedatalabs]

Please download the file from the link provided in the description box. Thanks!

[@kristen92431]

Can you provide a direct link? I cannot find the files anywhere on the site.

[@hospitalitytech7189]

hello I have queries about MS form on 0365 web access and database if possible can we have a call

[@badchimagarpakundiakishore430]

too much coding

[@badchimagarpakundiakishore430]

boring

[@jeffersonkosi8177]

Hi sir, I'm Jefferson. I followed you tutorials strictly but I keep getting this Run-time erro '438' after clicking submit. It displays...'Object doesn't support this property or method' and when I click on debug it take me to 'ValidEmail = .Text(eMail). Please I don't know what to do next

[@mohamednayeem2602]

Syntax Error IN From clause.-2147217900 I m getting this error. Could you please let me know what is the issue with this

[@TravelTalkies79]

I am getting debug on nconnection.close please help

[@mathematicswithpython2170]

I do appreciate to this work its really very helpful for me but could you guide us with other video which consist on data Manipulation or import or export with images picture from database to vba and vice versa

[@thedatalabs]

Thanks for your appreciation! I will upload a tutorial covering all the ADO features. Please keep watching. Thanks!