A Beginner’s Guide to C-Sharp-CH17: Reading Excel and MS Access Files (ABGC)

Chapter 17 (43 pages) shows how to read data from an Excel Sheet or from an Access database. See Chapter 25 for MSSQL.Topics: Adding the COM library. Loading an Excel object. Opening a sheet; looping through a sheet; skipping title rows. Using Microsoft Access to populate a combo-box. Building an Access Table and Relationship (Access). Using Access to run queries.About this series: A beginner's guide to C-Sharp programming with Microsoft's Visual Studio, 2017. A complete programming guide. Simple, step-by-step, fully illustrated. Tailored for new and novice developers. Discusses basic techniques that all programmers need to learn. This series is sold by Chapters at a low cost. A total of 28 chapters, in three volumes. Over 1800 pages, 900 quality illustrations. Why am I distributing by chapter? To keep the cost down and to keep each section manageable. This book acts as a reference guide. Topics are covered in great detail, with little time spent on theory. The goal of these books are to solve programming problems quickly and efficiently. I hope you enjoy reading and studying these pages as much as I have enjoyed writing them. --TRW

Author: Tim R. Wolf

Learn more