From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Create tables from flat files

Create tables from flat files - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial Buy for my team

Create tables from flat files

“

- [Narrator] If you're looking to import an entire table including its column structure and data into a SQL server database, then there's a more modern wizard to help you do that than the one that we saw in the last movie. You can find it by right-clicking on the database, I'm going to choose the Landon Hotel database again. Coming to tasks, and then coming down, and this time instead of import data, I'm going to choose import flat file. Already you can see that the graphics and the icons on this starting page of the wizard feels more modern. This describes what the wizard does, and when you're ready, go ahead and press the next button. First we need to choose the file that we're going to be importing. Now click on the browse button and we'll go back out to my desktop, in the exercise files, chapter three, and this time, I'm going to import the Landon Employees table. I'll go ahead and select this CSV file and press open.…

Contents