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 from these sources into SQL Server.
KeywordsExcel Spreadsheet Access Database Access File Connection Manager Excel Worksheet
Unable to display preview. Download preview PDF.