Your videos are the most helpful ones to me. I have been watching for several years and used your techniques at my workplace. I have created many useful automation files, thank you very much.
I would like to ask if DELETE is allowed in worksheet. I have used this in worksheet but encountered this message "Deleting data in a linked table is not supported by this ISAM." I 'm not sure what does linked table mean here because I have only one sheet. [Sheet1$]
Wonderful set of videos! Can you tell me the best approach to insert or update records in the Film table if your using drop down list to enter the FK fields like Director, Genre, etc?
Great videos! Question, you advise on video to install OLE driver...for excel connection to SQL server, is that needed? I was under the impression excel can connect to SQL server without any additional software, just plain ADO. Thanks
Thanks Frank! ADO needs a driver or provider to talk to a data source. You can use several different drivers to talk to SQL Server, some of which don't need an additional installation. Microsoft's current recommendation for SQL Server is the MSOLEDBSQL driver and that's the one used in these videos. I don't know if the MSOLEDBSQL driver is included with any SQL Server installation - the MS documentation says it's a stand-alone API and if you'd like to install it you can use this link docs.microsoft.com/en-gb/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15 We have a video which explains how to install it along with a brief history of OLEDB drivers for SQL Server which you can see here ruclips.net/video/OWKae1pTTnE/видео.html Alternatively, you can read Microsoft's take on the subject here docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15#different-generations-of-ole-db-drivers I hope that helps!
Hi, Very clear and helpful. I am trying to follow your way to open communication with SQL database through VBA code of FactoryTalk SE HMI. I am facing an error "SQL server network interface: connecting string is not valid" any suggestion? Also My database is located on different Pc its not local, is there any place that I need to edit to point to my SQL server PC ? Thank you and appreciate your support in advance
Hi Noor! I'm sorry it's difficult to say without knowing what your connection string looks like and what your server name is. I'd take a look at the connection string patterns here www.connectionstrings.com/ole-db-driver-for-sql-server/ I hope it helps!
Great Sir I really enjoy this training session and exciting for another session thanks for your guidance that I make my project. My project is A data entry form where my team entry or update there records in excel sheet and its save data in my remote SQL server. I am using 'MSOLEDBSQL' provider its working perfect in my system but when I run another system showing error 'Run time error 3706 - Provider cannot be found. It may not be properly install '. if possible how can i fix its Now I have 2 questions first 1 - I want to enter multiple Entries in my SQL database from excel sheet using loop. Second is how to make such criteria like my entries only updated by me or i can not change another entries means no one can change other ones entries only they change own enters how to make this type criteria whenever everyone have to access to see other rights.
Hi Pankaj! Every machine which runs the code needs to have the MSOLEDBSQL driver installed docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15 For question 1 using a loop, which part are you having trouble with? For question 2 the best option is Row Level Security but you'll need to configure this in SQL Server rather than your VBA code docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15 I hope that helps!
Yes but you might find the videos which use Access more useful: ruclips.net/video/HE9CIbetNnI/видео.htmlfeature=shared ruclips.net/video/p_IhfObVc6A/видео.htmlfeature=shared ruclips.net/video/-c2QvyPpkAM/видео.htmlfeature=shared
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
I have been watching your videos for 4 years. They are really helpful.
I really appreciate your work.
And I really appreciate you watching, thank you!
Your videos are the most helpful ones to me. I have been watching for several years and used your techniques at my workplace. I have created many useful automation files, thank you very much.
Thank you Andrew! You are my Guru ... wonderful work!
Thank you Rajesh! It's always nice to hear when people enjoy the videos, thank you for taking the time to leave a comment!
Wonderful! Thank you, Andrew!!! You are brilliant as always!
Thanks Alexander! I appreciate the comments as always!
Thank you very much for continuous wonderful videos
You're very welcome Yasser, thank you for continuing to watch them!
Thank you once again. Just found the answer to my question.
Happy to hear that, thanks for watching!
I would like to ask if DELETE is allowed in worksheet. I have used this in worksheet but encountered this message "Deleting data in a linked table is not supported by this ISAM." I 'm not sure what does linked table mean here because I have only one sheet. [Sheet1$]
@@MyAudioBookCompilation No, the Delete statement isn't supported when connecting to an Excel workbook.
Wonderful set of videos! Can you tell me the best approach to insert or update records in the Film table if your using drop down list to enter the FK fields like Director, Genre, etc?
Hi Sir,
Thank you for all your videos.
Kindly make a video how can we extract dump from Avaya CMS using VBA code
Great videos!
Question, you advise on video to install OLE driver...for excel connection to SQL server, is that needed?
I was under the impression excel can connect to SQL server without any additional software, just plain ADO.
Thanks
Thanks Frank! ADO needs a driver or provider to talk to a data source. You can use several different drivers to talk to SQL Server, some of which don't need an additional installation. Microsoft's current recommendation for SQL Server is the MSOLEDBSQL driver and that's the one used in these videos. I don't know if the MSOLEDBSQL driver is included with any SQL Server installation - the MS documentation says it's a stand-alone API and if you'd like to install it you can use this link docs.microsoft.com/en-gb/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15
We have a video which explains how to install it along with a brief history of OLEDB drivers for SQL Server which you can see here ruclips.net/video/OWKae1pTTnE/видео.html
Alternatively, you can read Microsoft's take on the subject here docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-ver15#different-generations-of-ole-db-drivers
I hope that helps!
Hi,
Very clear and helpful.
I am trying to follow your way to open communication with SQL database through VBA code of FactoryTalk SE HMI. I am facing an error "SQL server network interface: connecting string is not valid" any suggestion?
Also My database is located on different Pc its not local, is there any place that I need to edit to point to my SQL server PC ?
Thank you and appreciate your support in advance
Hi Noor!
I'm sorry it's difficult to say without knowing what your connection string looks like and what your server name is. I'd take a look at the connection string patterns here www.connectionstrings.com/ole-db-driver-for-sql-server/
I hope it helps!
Great Sir I really enjoy this training session and exciting for another session
thanks for your guidance that I make my project. My project is A data entry form where my team entry or update there records in excel sheet and its save data in my remote SQL server. I am using 'MSOLEDBSQL' provider its working perfect in my system but when I run another system showing error 'Run time error 3706 - Provider cannot be found. It may not be properly install '. if possible how can i fix its Now I have 2 questions first 1 - I want to enter multiple Entries in my SQL database from excel sheet using loop. Second is how to make such criteria like my entries only updated by me or i can not change another entries means no one can change other ones entries only they change own enters how to make this type criteria whenever everyone have to access to see other rights.
Hi Pankaj! Every machine which runs the code needs to have the MSOLEDBSQL driver installed docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-ver15
For question 1 using a loop, which part are you having trouble with?
For question 2 the best option is Row Level Security but you'll need to configure this in SQL Server rather than your VBA code docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15
I hope that helps!
Does any of this work with Access
Yes but you might find the videos which use Access more useful:
ruclips.net/video/HE9CIbetNnI/видео.htmlfeature=shared
ruclips.net/video/p_IhfObVc6A/видео.htmlfeature=shared
ruclips.net/video/-c2QvyPpkAM/видео.htmlfeature=shared