From the course: SQL Server 2014 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Importing data

Importing data - SQL Server Tutorial

From the course: SQL Server 2014 Essential Training

Start my 1-month free trial

Importing data

“

- Now let's look at importing some data. First, I would like to create a new empty table, in which we will import the data. So I've staged some code for you in your exercise files. We want to go ahead and take all of that and copy and paste it into a new query window. And this is just going to create a new table HumanResources.Department_Temp. So, a temporary table that we will just use to hold the imported data. Go ahead and execute that. It says commands completed successfully that's good and I will refresh my list of tables and we should see it in there: HumanResources.Department_Temp, excellent. So now for the import, I'll right-click on AdventureWorks2014, go to tasks, and import data. And again, that pulls up the SQL Server Import and Export Wizard. On the first page, I'll click next. For my Data Source, I'm going to use the text file we created in the previous exercise. So for Data Source, we'll use a Flat File Source and for the file name, I'll click browse, and go to the file…

Contents