Using ADO to Access Excel, Part 1

Advanced Search

June 25, 2008 Using ADO to Access Excel, Part 1 Connect to and modify your spreadsheets A Web Exclusive from Windows IT Pro Jim Turner Feature InstantDoc #99123 Windows IT Pro	Email this Article Printer Friendly Reader Comments Digg This Del.icio.us RSS
View this exclusive article with VIP access -- click here to join \| See More ActiveX Data Objects (ADO) Articles Here \| Reprints \| Or sign up for our VIP Monthly Pass!

ActiveX Data Objects (ADO) can be used to access virtually any type of database via VBScript, as well as from a variety of other programming languages. In this article I’ll focus on how to use ADO to connect to and access data contained within Microsoft Excel spreadsheets using VBScript. (For bas . . .

Already a VIP member?
Please log on to view the full article

Why become a VIP member?

	VIP-only online access
	VIP CD delivered twice a year: offline access to the entire Windows IT Pro article library
	Monthly issue of your choice of Windows IT Pro or SQL Server Magazine

Finally I have found an article that clearly explains and demonstrates the basic workings of Excel! Thank You Logman98

logman98 September 02, 2008 (Article Rating:

)

You must be a registered user or online subscriber to comment on this article. Please log on before posting a comment. Are you a new visitor? Register now

Learning Path Scripting Pro VIP Resources
"ADO Scripts Enable Easy AD Searches"

"Introduction to ADO"

"Much Ado About ADO"

Microsoft Resources
"ExcelADO demonstrates how to use ADO to read and write data in Excel workbooks"

"How To Use ADO with Excel Data from Visual Basic or VBA"

"Using ADO to Query an Excel Spreadsheet"

Related Articles Introduction to ADO

Much Ado About ADO

Related Events Check out our list of Free Email Newsletters!

Scripting eBooks Keeping Your Business Safe from Attack: Encryption and Certificate Services

Best Practices for Managing Linux and UNIX Servers

Building an Effective Reporting System

Related Scripting Resources Introducing Left-Brain.com, the online IT bookstore
Looking for books, CDs, toolkits, eBooks? Prime your mind at Left-Brain.com

Discover Windows IT Pro eLearning Series!
Clear & detailed technical information and helpful how-to's, all in our trademark no-nonsense format

ADS BY GOOGLE

Job Openings in IT		SPONSORED LINKS		FEATURED LINKS
		Calculate your savings now See how SAN is 57% cheaper than DAS over three years Free CDs Offer Fundamental Content for IT Pros Are you up to speed on the latest technologies and solutions? Don't miss out on your chance to get up to speed quickly on fundamental, in-depth information on some of the hottest topics in our library of content. Let Your Users Reset Their Own Passwords: Free Download Try a 30 day free trial of Desktop Authority Password Self-Service – it provides an easy-to-use, robust system for allowing users to reset their own forgotten passwords or locked accounts.		Exchange Server 2010: Deploying Unified Communications - Virtual conference December 1, 2009 - Free Registration. Build your Unified Communications future on a strong Exchange Server 2010 foundation. Get Windows IT Pro & Mark Minasi’s Favorite Power Tools Guide Order Windows IT Pro now and get "More of Mark Minasi's Favorite Power Tools"--a in-depth guide to the most useful Windows commands --FREE with your paid order! Subscribe today, and save 58% off the cover price! Migration, Virtualization, Availability, and Desktop Management Realize the importance of a workload optimization strategy...it can affect your bottom line! Deep Dive into VMware vSphere, eLearning Series Join John Savill to explore the major functionality capabilities of the vSphere virtualization platform, including identification of the changes from ESX 3.5.