ADO Stands for Active X Data Objects, is Microsoft’s Client-Server technology to access the data between Client and Server.ADO can’t access the data source directly, it will take help of OLE DB Provider to communicate with the data source.
To add a link to a recently used file, on the Insert tab, choose Link and select any file from the displayed list.You can now also draw free-form lines using the pencil for marking areas to keep or remove—no more being limited to drawing just straight lines.To see how this works let’s do a short walkthrough of sample 6 that creates a report on a directory in the file system. First sheet is a list of subdirectories and files, with an icon, name, size, and dates. If you’re going to follow along you’ll need to have access to (and some familiarity with) Share Point Central Administration…you’ll need to become good friends with your Share Point administrator (They’re probably a really nice person, you should take them out to lunch).While this walkthrough is meant to be read in order, I’ve decided to break it up into section as follows for readability (hopefully) After all, security is kind of a big deal, particularly when it comes to data.
You can select the check box for any of the library you want to add in your excel and click button from the right and you will be able to use the methods and objects which resides in that library.