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
- Standard Operating Procedure
- 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