• 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!


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.




Should be familiar with SQL Server and Excel.


Video Link



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



Support Materials




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.