Connecting to SQL Server 2008 with Microsoft Excel 2010

Miller SD. Connecting to SQL Server 2008 with Microsoft Excel 2010. National Park Service Arctic Inventory and Monitoring Network. Fairbanks, AK

ARCN-DMSOP-2013-2. Most biologists are accustomed to working with their data in an Excel spreadsheet environment but may be unfamiliar with extracting data from a Sql Server database. The process is quite simple and the procedure below describes how to pull results from an SQL Server view (precompiled query) into Microsoft Excel 2007.

Type
Guidance
Authors
Miller, Scott
Publisher
National Park Service Arctic Inventory and Monitoring Network. Fairbanks, AK
Units
ARCN , CAKN
Keywords
Data, Data Management, excel, import, SQL server, Standard Operating Procedure

Full text (PDF)

Collections

Browse the catalog