The ABCs of ADO

Here's what you need to know to start using ActiveX Data Objects (ADO) in VBScript scripts to interact with a variety of data sources.

Karen Bemowski

July 31, 2008

1 Min Read
ITPro Today logo

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

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like