Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.
Integrating Excel and Access and over 300,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
47 used & new from $11.52

Have one to sell? Sell yours here
 
   
Integrating Excel and Access
 
 
Start reading Integrating Excel and Access on your Kindle in under a minute.

Don’t have a Kindle? Get yours here.
 
  

Integrating Excel and Access (Paperback)

by Michael Schmalz (Author)
Key Phrases: excel application, design view, worksheet set, Nothing Set, Public Sub, Close Set (more...)
3.5 out of 5 stars See all reviews (14 customer reviews)

List Price: $39.95
Price: $26.37 & this item ships for FREE with Super Saver Shipping. Details
You Save: $13.58 (34%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

29 new from $21.34 18 used from $11.52
Also Available in: List Price: Our Price: Other Offers:
Kindle Edition (Kindle Book) $17.59
Like this book? Find similar titles from O'Reilly and Partners in our O'Reilly Bookstore.

Best Value

Buy Analyzing Business Data with Excel and get Integrating Excel and Access at an additional 5% off Amazon.com's everyday low price.

Analyzing Business Data with Excel + Integrating Excel and Access
Buy Together Today: $54.24

Show availability and shipping details

  • Analyzing Business Data with Excel

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • This item: Integrating Excel and Access

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

Access Cookbook, 2nd Edition

Access Cookbook, 2nd Edition

by Andy Baron
4.6 out of 5 stars (22)  $32.97
Microsoft Access Data Analysis: Unleashing the Analytical Power of Access

Microsoft Access Data Analysis: Unleashing the Analytical Power of Access

by Michael Alexander
4.4 out of 5 stars (19)  $26.39
Access Data Analysis Cookbook (Cookbooks)

Access Data Analysis Cookbook (Cookbooks)

by Ken Bluttman
5.0 out of 5 stars (6)  $31.49
Access Database Design & Programming (3rd Edition)

Access Database Design & Programming (3rd Edition)

by Steven Roman
4.1 out of 5 stars (44)  $23.07
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET (2nd Edition) (Addison-Wesley Microsoft Technology Series)

by Rob Bovey
4.8 out of 5 stars (28)  $37.79
Explore similar items

Editorial Reviews

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

About the Author
Michael Schmalz has worked for a variety of banks, including MBNA, and teaches Excel and Access at Penn State. He currently spends most of his time as a consultant, focused on improving business analysis with desktop and database tools.


Product Details

  • Paperback: 232 pages
  • Publisher: O'Reilly Media, Inc.; illustrated edition edition (November 1, 2005)
  • Language: English
  • ISBN-10: 0596009739
  • ISBN-13: 978-0596009731
  • Product Dimensions: 9.1 x 6.8 x 0.7 inches
  • Shipping Weight: 14.9 ounces (View shipping rates and policies)
  • Average Customer Review: 3.5 out of 5 stars See all reviews (14 customer reviews)
  • Amazon.com Sales Rank: #163,382 in Books (See Bestsellers in Books)

    Popular in this category: (What's this?)

    #67 in  Books > Computers & Internet > Computer Science > Modeling & Simulation

Inside This Book (learn more)

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

 

Customer Reviews

14 Reviews
5 star:
 (5)
4 star:
 (4)
3 star:
 (1)
2 star:
 (1)
1 star:
 (3)
 
 
 
 
 
Average Customer Review
3.5 out of 5 stars (14 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
36 of 38 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.
Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)



 
34 of 38 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.

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?
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
17 of 20 people found the following review helpful:
5.0 out of 5 stars Finally, someone puts the pieces together., May 21, 2006
By Christopher T. Fennell (Fullerton, CA United States) - See all my reviews
(REAL NAME)   
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
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
Ad
 
Most Recent Customer Reviews

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 20 months ago by Scott T. Roche

4.0 out of 5 stars Needed Coverage of a Specific Topical Area
"Integrating Excel and Access" covers the topic spelled out in the book's title...the integration of Microsoft Excel and Microsoft Access. Read more
Published 20 months ago by K. Scott Proctor

1.0 out of 5 stars A wordy collection of Excel code
The title of this book is misleading. 70% of the book covers Excel and how to make Excel integrate into other platforms and applications. Read more
Published on May 31, 2007 by MGraham

3.0 out of 5 stars What about Controlling Access from Excel
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. Read more
Published on December 30, 2006 by Always Learning

1.0 out of 5 stars This book is useless.
Although the sevice was pretty good, item arrived on time, etc. The book is almost useless.
Published on December 27, 2006 by Bo Zhang

4.0 out of 5 stars Great for Office Automation
I code in Access VBA but need to push data to excel spreadsheets and format the results. This book has the answers. Read more
Published on November 3, 2006 by M. Copeland

5.0 out of 5 stars EXCELLENT!!!!!
Do you use Microsoft Office to handle data? If you do, then this book is for you! Author Michael Schmalz, has done an outstanding job of writing a book that will show you how... Read more
Published on May 14, 2006 by John R. Vacca

5.0 out of 5 stars Shows how to combine the two programs to get the best from both
Michael Schmalz's shows how to combine the two programs to get the best from both. All too often Excel and Access users remain separate; yet user interfaces exist which allow... Read more
Published on May 2, 2006 by Midwest Book Review

4.0 out of 5 stars Excellent for Beginners and Intermediates
I have quite a bit of experience with Excel and I am new to using Access. Right now, I am writing tools for business use and some personal use and this book has helped me a lot... Read more
Published on April 9, 2006 by John Carioto

5.0 out of 5 stars A must have for anyone who uses Office programs together!!!
I would like to congratulate the author Michael Schmalz on writing a book that is actually beneficial to a great number of Office users who have to manually integrate data between... Read more
Published on December 31, 2005 by Brian P. Chisholm

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
   


Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Shop Tool Storage in Home Improvement

Shop tool storage in Home Improvement
Check out the huge selection of tool storage and organization products offered by Amazon.com.

See more in the Power & Hand Tools Store

 

Best Books of 2008

Best of 2008
Find our top 100 editors' picks as well as customers' favorites in dozens of categories in our Best Books of 2008 Store.
 

Summer Reading for Kids & Teens

Summer Reading for Kids and Teens
Discover everything from beach reads and board books to teen romance and action-adventure series in Summer Reading for Kids & Teens. And, check off the kids' required reading lists in our Summer School Reading Store.
 

Best Books

Best of the Month
See our editors' picks and more of the best new books on our Best of the Month page.
 
Ad

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Free
Free by Chris Anderson
Paranoia
Paranoia by Joseph Finder
My Soul to Lose
My Soul to Lose by Rachel Vincent
Darkfever
Darkfever by Karen Marie Moning

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates