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 Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

ADS BY GOOGLE

Job Openings in IT		SPONSORED LINKS		FEATURED LINKS
		Get Microsoft Microsoft Certified With Train Signal Computer Training Train Signal’s computer training software videos will teach you the skills you need to get certified and gain experience in areas like Windows Server 2008, Exchange Server, SharePoint Server, and more.		Get Mark Minasi’s Windows Server 2008 Audio CDs "Windows expert, consultant and best-selling author Mark Minasi shows you if 2008 is right for you and, if so, how to get the most out of it! Desktop Management is a Never-Ending Job for Administrators Get a complete desktop management solution to centralize the management of thousands of desktops that will help you keep up with increased demand with limited manpower. Integrate Fax Servers into Your Unified Communications Plan In this fundamentals eBook you will learn how you can implement a solution that is easy to support, secure, and integrate. Take Control of Your Email Optimize your email storage – Download this white paper to learn key how-to’s in email storage management. Get Windows IT Pro To Go! The Windows IT Pro Magazine Master CD is a powerful combination of content and convenience. Order now, and save up to 25%--plus you’ll get online access to new articles each and every month! Subscribe today!