Advertisement

Sourcing Data from MS Office Applications

  • Adam Aspin

Abstract

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.

Keywords

Excel Spreadsheet Access Database Access File Connection Manager Excel Worksheet 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Adam Aspin 2012

Authors and Affiliations

  • Adam Aspin

There are no affiliations available

Personalised recommendations