Step by Step Guide to Reading the Data into Misrosoft SQL
Run your computer as an administrator. Turn off your computer and turn it back on as an administrator.
Unzip the Data.zip file. Unzip every DxAge_1 to DxAge_4 files. You must unzip the .csv files as well. The best place to unzip the files is My documents or Desktop.
Go to All Programs, right click on MS SQL Studio Manager (SSMS):
Log in to the server, use default settings.
Enter new database name (for example HAP 752):
Go to the new database (HAP752), right click ->Tasks -> Import Data
Use Wizard to import .csv files (one by one).
Choose a Data Source:
Click Browse and find your unzipped file:
When you find the file (you have to do it one by one), click NEXT
And Next again.
On the page "Choose a Destination" choose "Sql Server Native Client":
"Select Source Tables and Views" -> Click Next:
Copyright © 1996 Farrokh Alemi, Ph.D. Most recent revision 08/03/2018. This page is part of the course on Statistical Process Improvement.