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 . . .

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 log on before posting a comment.

If you don't have a username & password, please 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!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.

ADS BY GOOGLE

Job Openings in IT		SPONSORED LINKS		FEATURED LINKS
		Register for Orion NPM v9 - Evaluation Affordable, easy-to-use network performance management with SolarWinds Orion – Free Trial! Want a Hardware-Independent Image? Binary Research, the Ghost people, shows you how to clone with 1! Maximize speed, performance and reliablity of your PCs and servers—automatically! Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now! Order Your Fundamentals CD Today! Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint.

Windows IT Pro Home

FAQ for Windows

WinInfo News
Europe Edition

About Us

Media Kit

Affiliates / Licensing

SQL Server Magazine

Office & SharePoint Pro

Windows Dev Pro

IT Job Hound

ITTV
IT Library

Technology Resource Directory

Connected Home

Windows Excavator

Windows SuperSite