Michael Alexander and
Geoffrey Clark
Microsoft
®
Excel
®
&
Access
™
Integration
with Office 2007
01_104880 ffirs.qxp 3/22/07 10:47 PM Page i
01_104880 ffirs.qxp 3/22/07 10:47 PM Page iv
Michael Alexander and
Geoffrey Clark
Microsoft
®
Excel
®
&
Access
™
Integration
with Office 2007
01_104880 ffirs.qxp 3/22/07 10:47 PM Page i
Microsoft
®
Excel
®
& Access™ Integration with Office 2007

ers should be aware that Internet Websites listed in this work may have changed or disap-
peared between when this work was written and when it is read.
For general information on our other products and services or to obtain technical support,
please contact our Customer Care Department within the U.S. at (800) 762-2974, outside the
U.S. at (317) 572-3993 or fax (317) 572-4002.
Library of Congress Control Number: 2007007062
Trademarks: Wiley, the Wiley logo, and related trade dress are trademarks or registered
trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other
countries, and may not be used without written permission. Microsoft, Excel, and Access
are trademarks or registered trademarks of Microsoft Corporation in the United States
and/or other countries. All other trademarks are the property of their respective owners.
Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.
Wiley also publishes its books in a variety of electronic formats. Some content that appears
in print may not be available in electronic books.
01_104880 ffirs.qxp 3/22/07 10:47 PM Page ii
Mike Alexander
For Mary, Ethan and Emma
Geoffrey Clark
For FairBear and LittlestBear,
the fairest and littlest of all bears in the land...
01_104880 ffirs.qxp 3/22/07 10:47 PM Page iii
01_104880 ffirs.qxp 3/22/07 10:47 PM Page iv
Mike Alexander is a Microsoft Certified Applications Developer (MCAD)
with over 14 years experience developing Office solutions for a wide array of
Companies and industries. He currently lives in Frisco, Texas, where he works
as a Senior Program Manager for a top technology firm. He is the author of
several books on data analysis using Excel and Access, and he is the principal
behind DataPigTechnologies.com, a site that offers free tutorials on Excel
and Access.
Geoff Clark holds an MBA from Duke University’s Fuqua School of Business

Richard Swadley
Vice President and Executive
Publisher
Joseph B. Wikert
Project Coordinator
Kristie Rees
Graphics and Production Specialists
Denny Hager
Stephanie D. Jumper
Jennifer Mayberry
Barbara Moore
Ronald Terry
Quality Control Technicians
John Greenough
Brian H. Walls
Proofreading and Indexing
Aptara
Anniversary Logo Design
Richard Pacifico
Credits
vii
01_104880 ffirs.qxp 3/22/07 10:47 PM Page vii
01_104880 ffirs.qxp 3/22/07 10:47 PM Page viii
About the Authors v
Acknowledgments xvi
Introduction xvii
Part I: Basic Integration Techniques 1
Chapter 1: Getting Excel Data into Access 3
Differences Between Access and Excel 4
Different Types of Excel Spreadsheets 4