| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Lecture - Importing Data Into SQL Server

Page history last edited by Dr. Ron Eaglin 11 years, 4 months ago

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

Comments (0)

You don't have permission to comment on this page.