Importing Data Into SQL Server

Summary of Video

A demonstration of pulling an XML file from Data.gov ( https://explore.data.gov/Health-and-Nutrition/MyPyramid-Food-Raw-Data/b978-7txq  ) and importing it into SQL Server. Demonstrates Excel and XML as steps in data import.

Prerequisites

Should be familiar with SQL Server and Excel.

Video Link

DSC Video Server - http://online1.daytonastate.edu/player2.php?id=f0204e1d3ee3e4b05de4e2ddbd39e076 

Support Materials

https://explore.data.gov/Health-and-Nutrition/MyPyramid-Food-Raw-Data/b978-7txq 

Importing Data from Excel into SQL Server using SQL - http://support.microsoft.com/kb/321686 

Importing Data into SQL Server using Wizard - http://msdn.microsoft.com/en-us/library/ms141209.aspx 

All Materials Copyright 2012 Dr. Ron Eaglin