Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE)

Опубликовано: 02 Апрель 2014
на канале: WiseOwlTutorials

82,961

520

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

You can buy our Introduction to Excel VBA book here https://www.lulu.com/shop/andrew-goul...

By Andrew Gould

You can download the files needed for the video here:
https://www.wiseowl.co.uk/videos/exce...

https://www.wiseowl.co.uk - The ADO Command object essentially allows you to write SQL statements directly into your VBA code and execute them on whichever database you've connected to - powerful stuff! This video focusses on the INSERT, UPDATE and DELETE statements to allow you to modify data based on information contained in your Excel workbooks. We'll cover how to build dynamic SQL statements and how to avoid the main danger of dynamic SQL. You'll also get an idea of how transactions work in databases, allowing you to revert your data back to a previous state if things go wrong with your code!

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!

На этой странице сайта вы можете посмотреть видео онлайн Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE) длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь WiseOwlTutorials 02 Апрель 2014, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 82,961 раз и оно понравилось 520 зрителям. Приятного просмотра!

1,699