CHAPTER 1
Sourcing Data from MS Office Applications
I suspect that many industrial-strength SQL Server applications have begun life as a much smaller MS Office-based idea, which has then grown and been extended until it has finished as a robust SQL Server application. In any case, two Microsoft Office programs—Excel and Access—are among the most frequently used sources of data for eventual loading into SQL Server. There are many reasons for this, from their sheer ubiquity to the ease with which users can enter data into Access databases and Excel spreadsheets. So it is no wonder that we developers and DBAs spend so much of our time loading data ...
Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
