Chapter 12. Controlling a Database from Excel Using ADO and DAO

IN THIS CHAPTER

Using DAO to Execute Action Queries
Using ADO to Execute Action Queries and Stored Procedures
Using DAO Recordsets to Move Data from Excel to a Jet Database
Using ADO to Move Data from Excel to a Database
Looking Ahead

Table of content

Managing Data with Microsoft Excel

ISBN: 789731002
EAN: N/A

Year: 2003
Pages: 134

BUY ON AMAZON

SQL Tips & Techniques (Miscellaneous)

Retrieving and Manipulating Data Through Cursors
Working with Ms-sql Server Information Schema View
Monitoring and Enhancing MS-SQL Server Performance
Writing Advanced Queries and Subqueries
Working with SQL Database Data Across the Internet

Visual C# 2005 How to Program (2nd Edition)

Structured Programming Summary
Simple Object Access Protocol (SOAP)
Exercises
C.3. The Locals and Watch Windows
F.1. Introduction

Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance

Cisco ASA All-in-One Solution
Summary
Authentication, Authorization, and Accounting (AAA)
Troubleshooting PKI
Configuration Management

Special Edition Using FileMaker 8

The Basics of Process Analysis
Creating Self-Relationships
Common Scripting Topics
Getting Started with Reporting
Putting the Finishing Touches on Your Documentation

Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))

Getting Visio and Diagram Help
Connecting Shapes in Flowcharts
Modifying Shape Connections
Importing Data to Create Organization Charts
Storing Information with Network Shapes

Digital Character Animation 3 (No. 3)

Conclusion
Facial Rigging
Acting Vs. Animating
Chapter Ten. Directing and Filmmaking
Characters and Story