Skip navigation

The ABCs of ADO

Learning how to use ActiveX Data Objects (ADO) in VBScript scripts is time well spent because you can use ADO to interact with a variety of data sources, including Active Directory (AD), Microsoft Excel spreadsheets, and Microsoft SQL Server and Microsoft Access databases. You can even use ADO to work with data in delimited text files. In the article "Introduction to ADO," Robert Sheldon discusses the ADO basics that you need to know no matter what type of data source you want to access. He goes over the five primary ADO objects—Connection, Command, Field, Parameter, and Recordset—and provides sample VBScript scripts that demonstrate how to use these objects. You can read how to use these objects and download the sample scripts at This article is open to registered users through September 4. (Registration is free and simple if you're not already a registered user.) If you enjoy reading this article, you can get more of this type of content by becoming a Windows IT Pro VIP subscriber at

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.