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

Veröffentlicht am: 02 April 2014
auf dem Kanal: 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!

Auf dieser Seite können Sie das Online-Video Excel VBA Introduction Part 32 - ADO (ActiveX Data Objects) SQL Statements (INSERT, UPDATE, DELETE) mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer WiseOwlTutorials 02 April 2014 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 82,961 Mal angesehen und es wurde von 520 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

1,699