Integrating Excel and Access and over 2 million other books are available for Amazon Kindle . Learn more
  • RRP: £26.50
  • You Save: £1.33 (5%)
FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Integrating Excel and Acc... has been added to your Basket
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: Expedited shipping available on this book. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.
Trade in your item
Get a £0.39
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Integrating Excel and Access Paperback – 11 Nov 2005

1 customer review

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£13.88 £2.64
£25.17 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.

Frequently Bought Together

Integrating Excel and Access + Microsoft Excel and Access Integration: With Microsoft Office 2007
Price For Both: £49.46

Buy the selected items together

Trade In this Item for up to £0.39
Trade in Integrating Excel and Access for an Amazon Gift Card of up to £0.39, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 236 pages
  • Publisher: O'Reilly Media; 1 edition (11 Nov. 2005)
  • Language: English
  • ISBN-10: 0596009739
  • ISBN-13: 978-0596009731
  • Product Dimensions: 17.8 x 1.4 x 23.3 cm
  • Average Customer Review: 3.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 826,832 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Publisher

This unique reference shows you how to combine the powerful analysis tools of Excel with the structured storage and more powerful querying of Access. It covers everything you need to know, including interfaces, object models, and code. Learn how to crunch and visualize data like never before. Perfect for all Microsoft Office users

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.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

3.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Most Helpful Customer Reviews

3 of 3 people found the following review helpful By Amazon Customer on 14 Dec. 2010
Format: Paperback Verified Purchase
The book did not deliver what I was realy looking for. I am a highly experienced Excel user but have problems in moving to Access. One of the reasons is the difference in terminology between the two products. For example Excel lookup tables are easy to use but Access uses a different process. I was hoping this book would cover this type of difference; it does not. It does cover several areas of interest to programmers but not all of us are so gifted and need to plod on without using VBA.

The book is more aimed at working with both products and using their specific strengths rather than teaching an excel user how to convert to access.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on (beta) 22 reviews
39 of 42 people found the following review helpful
Good primer on a niche subject 16 Jan. 2006
By JRK - Published on
Format: Paperback
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.
39 of 45 people found the following review helpful
Hodgepodge of topics 22 Jan. 2007
By Amazon reviewer - Published on
Format: Paperback
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.

So out of all of the above, all it has to say about importing Excel data into Access is many pages showing how to use the import wizard which is pretty intuitive anyway but doesn't say much about pulling Excel data into Access using VBA. What about getting DoCmd.TransferSpreadsheet to work as smart as manually using the Access import wizard?
24 of 28 people found the following review helpful
Finally, someone puts the pieces together. 21 May 2006
By Christopher T. Fennell - Published on
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.

Even if you only desire to be an intermediate user, this book will make using Excel data in Access so much easier. It will of course also make it easier for you to get data from Access into Excel, and I am not talking about copying the results from a select query into an Excel worksheet. I am talking about using either the ODBC connection, or using SQL in VBA, to filter the data coming out of Access into Excel. As such, you get only the records that you want, with the click of a button.

In a nutshell, this book is a must for anyone that uses Excel and Access for a common task. I have read thru this book twice already, and it is my number one reference book. Once you open this book, you too will be asking, why it has taken so long for someone to put using the two programs together in one book.

Christopher T. Fennell

Microsoft Office Application Developer
10 of 11 people found the following review helpful
What about Controlling Access from Excel 30 Dec. 2006
By Always Learning - Published on
Format: Paperback
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.
6 of 7 people found the following review helpful
A wordy collection of Excel code 1 Jun. 2007
By MGraham - Published on
Format: Paperback
The title of this book is misleading. 70% of the book covers Excel and how to make Excel integrate into other platforms and applications. At 190 pages, that means the author spends about 60 pages covering Access (and that's only to cover intuitive tasks accomplished through the user interface). The examples are mostly Excel VBA code; none of which are particularly new or mind blowing.

The strangest part of this book is the author inexplicably puts a half-hearted Excel object model in an Appendix. But no object model for Access? Can anyone say filler? Seems a shame to waste such an interesting topic on this extremely wordy collection of Excel code. The positive: this book is thin enough to fit perfectly under my wobbly desk.
Were these reviews helpful? Let us know