Start reading Integrating Excel and Access on the free Kindle Reading App or on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here.

Deliver to your Kindle or other device

Enter a promotion code
or gift card

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Integrating Excel and Access [Kindle Edition]

Michael Schmalz
3.4 out of 5 stars  See all reviews (21 customer reviews)

Digital List Price: $31.99 What's this?
Print List Price: $39.95
Kindle Price: $17.27
You Save: $22.68 (57%)

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your email address or mobile phone number.


Amazon Price New from Used from
Kindle Edition $17.27  
Paperback $29.25  
Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

In a corporate setting, the Microsoft Office Suite is an invaluable set of applications. One of Offices' biggest advantages is that its applications can work together to share information, produce reports, and so on. The problem is, there isn't much documentation on their cross-usage. Until now.

Introducing Integrating Excel and Access, the unique reference that shows you how to combine the strengths of Microsoft Excel with those of Microsoft Access. In particular, the book explains how the powerful analysis tools of Excel can work in concert with the structured storage and more powerful querying of Access. The results that these two applications can produce together are virtually impossible to achieve with one program separately.

But the book isn't just limited to Excel and Access. There's also a chapter on SQL Server, as well as one dedicated to integrating with other Microsoft Office applications. In no time, you'll discover how to:

  • Utilize the built in features of Access and Excel to access data
  • Use VBA within Access or Excel to access data
  • Build connection strings using ADO and DAO
  • Automate Excel reports including formatting, functions, and page setup
  • Write complex functions and queries with VBA
  • Write simple and advanced queries with the Access GUI
  • Produce pivot tables and charts with your data

With Integrating Excel and Access, you can crunch and visualize data like never before. It's the ideal guide for anyone who uses Microsoft Office to handle data.

Editorial Reviews

About the Author

Michael Schmalz works in financial services and performs business and technology consulting in a variety of industries. He has done technical editing for O'Reilly on several Microsoft Office books and authored "Integrating Excel and Access" and "C# Database Basics". Michael has a degree in Finance from Penn State. He lives with his wife and children in Pennsylvania.

Product Details

  • File Size: 2113 KB
  • Print Length: 236 pages
  • Simultaneous Device Usage: Unlimited
  • Publisher: O'Reilly Media; 1 edition (February 9, 2009)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B0026OR2TK
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Lending: Not Enabled
  • Amazon Best Sellers Rank: #386,068 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

Customer Reviews

Most Helpful Customer Reviews
39 of 42 people found the following review helpful
4.0 out of 5 stars Good primer on a niche subject January 15, 2006
The book does a pretty good job covering the various techniques of data exchange between two applications. Usually in an Access-only or Excel-only reference, there would be a chapter spent on this topic max. However, one of my surprises after spending some time with the book is how often VBA is used in example after example. I think a more appropriate title or at least subtitle would have VBA in it. That is why I gave it 4 stars instead of 5.

I think you have to be at least an intermediate level user with both Excel and Access to even understand why you'd want to use these two applications together, and I think at least an intermediate comfortability with VBA is warranted. One of the first VBA examples of the book is where the author creates a reusable module for creating an ADO connection... great example, it sets a tone for the reader's comfortability with VBA.

The author also includes some examples of using Excel/Access data with other applications, including Word, SQL Server, and MapPoint (which might be a bit of a stretch).

Overall, it's a good book because it forays into a topic with very minimal coverage and succeeds by providing solid examples across a wide range of situations. You'd be hard pressed to use every chapter in the book due to the wide coverage, but I certainly had no problems diving into a chapter and immediately finding applicability to my related business problems.
Was this review helpful to you?
39 of 45 people found the following review helpful
2.0 out of 5 stars Hodgepodge of topics January 22, 2007
This book contains a hodgepodge of topics loosely fitting in with Access and Excel. Unfortunately, the title is misleading. You would expect an entire book on automating data movement between Excel and Access (BOTH from AND to), but you don't entirely get that. The XML stuff and integration with other applications is interesting but not necessarily relevant. There's also a great discussion of Excel's R1C1 (relative address) and A1 (absolute address) style notation.

Let's go through the chapters:

1. Intro

2. Using Excel's Uset Interface

3. Data Access from Excel VBA (using Excel to pull data in)

4. Integration from the Access Interface which covers exporting data to Excel.

5. Using Access VBA to Automate Excel (about pushing/exporting a spreadsheet from Access to an Excel window using Access VBA)

6. Using Excel Charts and Pivot Tables with Access Data

7. Leveraging SQL Server Data with Microsoft Office... part of this talks about how Excel can AVOID Access (the opposite of what the book is supposed to be about!)

8. Advanced Excel Reporting Techinques... bad title, good topic. This is about using Access VBA to create reports in an Excel spreadsheet.

9. Using Access and Excel Data in Other Applications (OTHER??? applications. Now we are looking at OTHER applications like Word, Powerpoint, and MapPoint. Interesting, but way off topic.)

10. Creating Form Functinality in Excel (another chapter about Excel, not integration)

11. Builing Graphical User Interfaces (an unnecessary Access tutorial)

12. Tackling an Integration Project (general discussion)

Then there's an appendix about Excel('s) Object Model and VBA Basics.
Read more ›
Comment | 
Was this review helpful to you?
24 of 28 people found the following review helpful
5.0 out of 5 stars Finally, someone puts the pieces together. May 21, 2006
Format:Paperback|Verified Purchase
I have spent the past ten years making my living developing integrated & automated financial systems using Excel, Access, and VBA for accounting and finance departments. That said, I literally have dozens of Excel, Access, and VBA books on my bookshelf. This is the only book that I have ever seen that integrates Excel and Access. It of course uses VBA to accomplish much of this.

Why it has taken so long for someone to put the pieces together in one book I am not sure. What I am sure of is how useful this book is. If you use Excel and Access this book is a must. This should be your primary reference for integrating and automating Excel and Access. You will learn better ways to do what you are already doing. You will also learn ways to do things that you never knew were possible. As a result, your applications will be more efficient, more powerful, more accurate, more reliable, and finally, you will be a better programmer/developer.

My work as a consultant puts me in a position to help others learn new ways to use Excel, Access, and VBA on a daily basis. When I show users what is possible, things that are covered in this book, they are not only impressed, they are amazed. They now do things that they never dreamed possible.

Integrating the two object models using VBA allows you to fully automate your applications/models. You can now do it minutes, if not seconds, what used to take you hours or days. You remove the possibility of the user making errors because the user is no longer manually manipulating the data (copying, pasting, etc.) You are not changing formulas, expressions, or criteria. You are allowing the computer to do all of that for you. This book, combined with advanced VBA makes true automation possible.
Read more ›
Comment | 
Was this review helpful to you?
10 of 11 people found the following review helpful
3.0 out of 5 stars What about Controlling Access from Excel December 30, 2006
I'd actually rate this 3.75 *'s, but that's not available. I find this excellent in the material it does cover, namely "controlling," if you will, Access from Excel. There simply are an insufficient number of books and documents covering the details of Microsoft automation, which was supposed to be one of hallmarks of using MS Office. However, I found nothing in the text going the other way - controlling Excel from Access. This is an inexcusable ommission, in my opinion. The book should be retitled so it's true content is clear.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Five Stars
good book, same as describe
Published 1 month ago by andrew
4.0 out of 5 stars Four Stars
Older book but still works with the current version especially if you are developing with MS Access and Excel
Published 5 months ago by rbaroniunas
2.0 out of 5 stars Did not get much out of this at all
I really got very little out of this book. Had high expectations. Cannot really put my finger on it but I think the problem was there was not much practical instruction and... Read more
Published 5 months ago by Obesessive Reader
5.0 out of 5 stars Excellect coverage of the topic
I have no idea how many shops there are out there that still use Excel (lots) and Access (not so many). Read more
Published 8 months ago by Bruce Baker
5.0 out of 5 stars Integration
Great book, teaches everything about integration of MS Excel and MS Access, using by the way Object Oriented Programming concepts.
Published 14 months ago by Tomaz V. Da Silva
2.0 out of 5 stars Look before you buy
Perhaps I shoul have looked better. This book is a few years old, which in cumputing is like half a century :(
Published 18 months ago by ferdinand
2.0 out of 5 stars unexpected
was looking for simplier way of using the database capability of Access into the charting strengths of Excel by integrating the two packages - all without VBA. Read more
Published on April 24, 2010 by Jose F. Feliciano
5.0 out of 5 stars Indispensable Resource
This ones a real keeper.

As a person who is both a Hobbyist Programmer, who is sometimes called upon to bring those skills into work, I have been searching for this book... Read more
Published on January 28, 2010 by T. R. LAVALLEY
2.0 out of 5 stars Good examples but some strange best practices
If you are looking for a quick read that gives you examples for Excel / Access projects, this is a useful book. Read more
Published on December 15, 2009 by Ken Murphy
1.0 out of 5 stars Virtually Useless
I bought this book because I was in a crunch and needed some quick help in getting a model I was building in Excel for a client to talk to the large dataset stored in Access (to... Read more
Published on November 25, 2007 by Scott T. Roche
Search Customer Reviews
Search these reviews only

More About the Author

Discover books, learn about writers, read author blogs, and more.

What Other Items Do Customers Buy After Viewing This Item?


There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
First post:
Prompts for sign-in

Look for Similar Items by Category