1 / 15

Utilizing ADO and SQL for Effective Data Management in Excel

Discover how to leverage ADO (ActiveX Data Objects) and SQL to enhance enterprise data management using Excel. This comprehensive guide walks you through the ADO architecture, enabling you to execute SQL queries on remote servers, retrieve and manipulate financial data efficiently, and display results seamlessly in your spreadsheets. You'll gain insights into object-oriented programming principles, including classes and instances, to better understand how to manage data effectively. Perfect for beginners and seasoned developers alike, this resource equips you with the knowledge to tackle real-world data challenges.

marin
Télécharger la présentation

Utilizing ADO and SQL for Effective Data Management in Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Putting VB & SQLTo Work Stefano Grazioli

  2. Critical Thinking • Incomplete videos • Easy meter

  3. AccessingEnterprise Data Using Excel & ADO

  4. Where is my Data? In memoryDATASET Databasetable on a DBMS In a file slow slow fast Your local machine Server

  5. ADO • ActiveX Data Object • MS Technology to manage enterprise data • Use ADO to run SQL queries on remote servers, collect the results, and present them to the user.

  6. Database Plumbing • Standard parts,put together in standard ways are called architectures • Standard parts are called ‘objects’

  7. Software Objects

  8. Software Objects • An object is a bundle of data and ‘methods’ • Object Classes and Object Instances Class = code to build an instance Instance = physical item running on your machine • Instances are built with the keyword new Dim myDeskClock As DeskClock = new DeskClock() Name, a variable Class name (type) keyword Method that creates the deskclock

  9. ADO architecture Client (your program on your machine) DB Server SqlConnection Connectionstring RemoteDataBase (financial data) SqlCommand SqlAdapter SQL Querystring DataSetDataTablesDataRows On yourSpreadsheet ListObject

  10. DEMO

  11. WINIT What Is NewIn Technology?

  12. You do the talking • Name, Major • Learning objectives • Things you like about the class • Things that can be improved • Attitude towards the Tournament

  13. Homework Using ADO to Retrieve Financial Data

  14. Suggestions • Make sure that you understand the ADO architecture diagram before coding.

More Related